I Just Installed Sql Server 2005. Where Is Enterprise Manager? And About Reporting..
1. So do I use that free tool SQL tool SQL Server Management Studio Express with the real version of SQL 2005? I do not see any program like enterprise manager that sql 2000 came with
2. We use Crystal reports 8.0 now. I noticed a new verison of crystal reports and also SQL reporting tools. But I am confused how the pricing works.. and which would cost more to use on production.. anyone can explain this ?
View Complete Forum Thread with Replies
Related Forum Messages:
Not Seeing Enterprise Manager After Installed Sql Server 2005
I am installing Sql Server 2005 on top of WindowsSBS 2003 and VS 2005. After I finish installing it I cannot see where the enterprise manager is. Basically I only get Microsoft Sql Server COnfiguration tools. Am I doing something wrong or this is the way it is suppose to be? I had installed all the features from SQL Server 2005. I appreciate any help!
View Replies !
Enterprise Manager Reporting Wrong Server Version
I am running MS SQL 2000.I recently ran a procedure in Query Analyzer from the Master db toclear out all replication information so I could start/recreate itagain.After I ran this procedure Enterprise Manager no longer showed theregistered server in the tree. When I tried to re-register it gave methe following message:"A connection could not be established to ([Database Name])""Reason: [SQL-DMO]Sql Server ([Database Name]) must be upgraded toversion 7.0 or later to be administered by this version of SQL-DMO""Please verify that sql is running and check your SQL serverregistration properties (by right click on the ([Database Name]) node)and try again."I ran the following procedure:<code>exec sp_configure N'allow updates', 1goreconfigure with overridegoDECLARE @name varchar(129)DECLARE @username varchar(129)DECLARE @insname varchar(129)DECLARE @delname varchar(129)DECLARE @updname varchar(129)set @insname=''set @updname=''set @delname=''DECLARE list_triggers CURSOR FORselect distinct replace(artid,'-',''), sysusers.name fromsysmergearticles,sysobjects, sysusers wheresysmergearticles.objid=sysobjects.idand sysusers.uid=sysobjects.uidOPEN list_triggersFETCH NEXT FROM list_triggers INTO @name, @usernameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping trigger ins_' +@nameselect @insname='drop trigger ' +@username+'.ins_'+@nameexec (@insname)PRINT 'dropping trigger upd_' +@nameselect @updname='drop trigger ' +@username+'.upd_'+@nameexec (@delname)PRINT 'dropping trigger del_' +@nameselect @delname='drop trigger ' +@username+'.del_'+@nameexec (@updname)FETCH NEXT FROM list_triggers INTO @name, @usernameENDCLOSE list_triggersDEALLOCATE list_triggersgoif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syspublications]') and OBJECTPROPERTY(id,N'IsUserTable')= 1) begin DECLARE @name varchar(129)DECLARE list_pubs CURSOR FORSELECT name FROM syspublicationsOPEN list_pubsFETCH NEXT FROM list_pubs INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping publication ' +@nameEXEC sp_dropsubscription @publication=@name, @article='all',@subscriber='all'EXEC sp_droppublication @nameFETCH NEXT FROM list_pubs INTO @nameENDCLOSE list_pubsDEALLOCATE list_pubsendGODECLARE @name varchar(129)DECLARE list_replicated_tables CURSOR FORSELECT name FROM sysobjects WHERE replinfo <>0UNIONSELECT name FROM sysmergearticlesOPEN list_replicated_tablesFETCH NEXT FROM list_replicated_tables INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'unmarking replicated table ' +@name--select @name='drop Table ' + @nameEXEC sp_msunmarkreplinfo @nameFETCH NEXT FROM list_replicated_tables INTO @nameENDCLOSE list_replicated_tablesDEALLOCATE list_replicated_tablesGOUPDATE syscolumns set colstat = colstat & ~4096 WHERE colstat &4096<>0GOUPDATE sysobjects set replinfo=0GODECLARE @name nvarchar(129)DECLARE list_views CURSOR FORSELECT name FROM sysobjects WHERE type='V' and (name like 'syncobj_%'ornamelike 'ctsv_%' or name like 'tsvw_%' or name like 'ms_bi%')OPEN list_viewsFETCH NEXT FROM list_views INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping View ' +@nameselect @name='drop View ' + @nameEXEC sp_executesql @nameFETCH NEXT FROM list_views INTO @nameENDCLOSE list_viewsDEALLOCATE list_viewsGODECLARE @name nvarchar(129)DECLARE list_procs CURSOR FORSELECT name FROM sysobjects WHERE type='p' and (name like 'sp_ins_%'ornamelike 'sp_MSdel_%' or name like 'sp_MSins_%'or name like 'sp_MSupd_%' ornamelike 'sp_sel_%' or name like 'sp_upd_%')OPEN list_procsFETCH NEXT FROM list_procs INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping procs ' +@nameselect @name='drop procedure ' + @nameEXEC sp_executesql @nameFETCH NEXT FROM list_procs INTO @nameENDCLOSE list_procsDEALLOCATE list_procsGODECLARE @name nvarchar(129)DECLARE list_conflict_tables CURSOR FORSELECT name From sysobjects WHERE type='u' and name like '_onflict%'OPEN list_conflict_tablesFETCH NEXT FROM list_conflict_tables INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping conflict_tables ' +@nameselect @name='drop Table ' + @nameEXEC sp_executesql @nameFETCH NEXT FROM list_conflict_tables INTO @nameENDCLOSE list_conflict_tablesDEALLOCATE list_conflict_tablesGOUPDATE syscolumns set colstat=2 WHERE name='rowguid'GODeclare @name nvarchar(200), @constraint nvarchar(200)DECLARE list_rowguid_constraints CURSOR FORselect sysusers.name+'.'+object_name(sysobjects.parent_ob j),sysobjects.namefrom sysobjects, syscolumns,sysusers where sysobjects.type ='d' andsyscolumns.id=sysobjects.parent_objand sysusers.uid=sysobjects.uidand syscolumns.name='rowguid'OPEN list_rowguid_constraintsFETCH NEXT FROM list_rowguid_constraints INTO @name, @constraint WHILE@@FETCH_STATUS = 0 BEGINPRINT 'dropping rowguid constraints ' +@nameselect @name='ALTER TABLE ' + rtrim(@name) + ' DROP CONSTRAINT '+@constraintprint @nameEXEC sp_executesql @nameFETCH NEXT FROM list_rowguid_constraints INTO @name, @constraint ENDCLOSE list_rowguid_constraintsDEALLOCATE list_rowguid_constraintsGODeclare @name nvarchar(129), @constraint nvarchar(129)DECLARE list_rowguid_indexes CURSOR FORselect sysusers.name+'.'+object_name(sysindexes.id), sysindexes.namefromsysindexes, sysobjects,sysusers where sysindexes.name like 'index%' andsysobjects.id=sysindexes.id and sysusers.uid=sysobjects.uidOPEN list_rowguid_indexesFETCH NEXT FROM list_rowguid_indexes INTO @name, @constraint WHILE@@FETCH_STATUS = 0 BEGINPRINT 'dropping rowguid indexes ' +@nameselect @name='drop index ' + rtrim(@name ) + '.' +@constraintEXEC sp_executesql @nameFETCH NEXT FROM list_rowguid_indexes INTO @name, @constraint ENDCLOSE list_rowguid_indexesDEALLOCATE list_rowguid_indexesGODeclare @name nvarchar(129), @constraint nvarchar(129)DECLARE list_ms_bidi_tables CURSOR FORselect sysusers.name+'.'+sysobjects.name fromsysobjects,sysusers where sysobjects.name like 'ms_bi%'and sysusers.uid=sysobjects.uidand sysobjects.type='u'OPEN list_ms_bidi_tablesFETCH NEXT FROM list_ms_bidi_tables INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping ms_bidi ' +@nameselect @name='drop table ' + rtrim(@name )EXEC sp_executesql @nameFETCH NEXT FROM list_ms_bidi_tables INTO @nameENDCLOSE list_ms_bidi_tablesDEALLOCATE list_ms_bidi_tablesGODeclare @name nvarchar(129)DECLARE list_rowguid_columns CURSOR FORselect sysusers.name+'.'+object_name(syscolumns.id) from syscolumns,sysobjects,sysusers where syscolumns.name like 'rowguid' andobject_Name(sysobjects.id) not like 'msmerge%'and sysobjects.id=syscolumns.idand sysusers.uid=sysobjects.uidand sysobjects.type='u' order by 1OPEN list_rowguid_columnsFETCH NEXT FROM list_rowguid_columns INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping rowguid columns ' +@nameselect @name='Alter Table ' + rtrim(@name ) + ' drop column rowguid'print @nameEXEC sp_executesql @nameFETCH NEXT FROM list_rowguid_columns INTO @nameENDCLOSE list_rowguid_columnsDEALLOCATE list_rowguid_columnsgoDeclare @name nvarchar(129)DECLARE list_views CURSOR FORselect name From sysobjects where type ='v' and status =-1073741824 andname<>'sysmergeextendedarticlesview'OPEN list_viewsFETCH NEXT FROM list_views INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping replication views ' +@nameselect @name='drop view ' + rtrim(@name )print @nameEXEC sp_executesql @nameFETCH NEXT FROM list_views INTO @nameENDCLOSE list_viewsDEALLOCATE list_viewsgoDeclare @name nvarchar(129)DECLARE list_procs CURSOR FORselect name From sysobjects where type ='p' and status = -536870912OPEN list_procsFETCH NEXT FROM list_procs INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping replication procedure ' +@nameselect @name='drop procedure ' + rtrim(@name )print @nameEXEC sp_executesql @nameFETCH NEXT FROM list_procs INTO @nameENDCLOSE list_procsDEALLOCATE list_procsgoif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergepublications]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergepublicationsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergesubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergesubscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syssubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM syssubscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysarticleupdates]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysarticleupdatesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[systranschemas]') and OBJECTPROPERTY(id,N'IsUserTable')= 1)DELETE FROM systranschemasGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergearticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergearticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergeschemaarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergeschemaarticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergesubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergesubscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysarticles]') and OBJECTPROPERTY(id,N'IsUserTable') =1)DELETE FROM sysarticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysschemaarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysschemaarticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syspublications]') and OBJECTPROPERTY(id,N'IsUserTable')= 1)DELETE FROM syspublicationsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergeschemachange]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergeschemachangeGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergesubsetfilters]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergesubsetfiltersGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSdynamicsnapshotjobs]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSdynamicsnapshotjobsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSdynamicsnapshotviews]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSdynamicsnapshotviewsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_altsyncpartners]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_altsyncpartnersGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_contents]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_contentsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_delete_conflicts]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_delete_conflictsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_errorlineage]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_errorlineageGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_genhistory]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_genhistoryGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_replinfo]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_replinfoGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_tombstone]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_tombstoneGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSpub_identity_range]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSpub_identity_rangeGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSrepl_identity_range]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSrepl_identity_rangeGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSreplication_subscriptions]') andOBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSreplication_subscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSsubscription_agents]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSsubscription_agentsGOif not exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syssubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)create table syssubscriptions (artid int, srvid smallint, dest_dbsysname,status tinyint, sync_type tinyint, login_name sysname,subscription_typeint, distribution_jobid binary, timestamp timestamp,update_modetinyint,loopback_detection tinyint, queued_reinit bit)CREATE TABLE [dbo].[syspublications] ([description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[name] [sysname] NOT NULL ,[pubid] [int] IDENTITY (1, 1) NOT NULL ,[repl_freq] [tinyint] NOT NULL ,[status] [tinyint] NOT NULL ,[sync_method] [tinyint] NOT NULL ,[snapshot_jobid] [binary] (16) NULL ,[independent_agent] [bit] NOT NULL ,[immediate_sync] [bit] NOT NULL ,[enabled_for_internet] [bit] NOT NULL ,[allow_push] [bit] NOT NULL ,[allow_pull] [bit] NOT NULL ,[allow_anonymous] [bit] NOT NULL ,[immediate_sync_ready] [bit] NOT NULL ,[allow_sync_tran] [bit] NOT NULL ,[autogen_sync_procs] [bit] NOT NULL ,[retention] [int] NULL ,[allow_queued_tran] [bit] NOT NULL ,[snapshot_in_defaultfolder] [bit] NOT NULL ,[alt_snapshot_folder] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[pre_snapshot_script] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[post_snapshot_script] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[compress_snapshot] [bit] NOT NULL ,[ftp_address] [sysname] NULL ,[ftp_port] [int] NOT NULL ,[ftp_subdirectory] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[ftp_login] [sysname] NULL ,[ftp_password] [nvarchar] (524) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[allow_dts] [bit] NOT NULL ,[allow_subscription_copy] [bit] NOT NULL ,[centralized_conflicts] [bit] NULL ,[conflict_retention] [int] NULL ,[conflict_policy] [int] NULL ,[queue_type] [int] NULL ,[ad_guidname] [sysname] NULL ,[backward_comp_level] [int] NOT NULL) ON [PRIMARY]GOcreate view sysextendedarticlesviewasSELECT *FROM sysarticlesUNION ALLSELECT artid, NULL, creation_script, NULL, description,dest_object,NULL, NULL, NULL, name, objid, pubid, pre_creation_cmd, status, NULL,type,NULL,schema_option, dest_ownerFROM sysschemaarticlesgoif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [dbo].[sysarticles]GOCREATE TABLE [dbo].[sysarticles] ([artid] [int] IDENTITY (1, 1) NOT NULL ,[columns] [varbinary] (32) NULL ,[creation_script] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL,[del_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[dest_table] [sysname] NOT NULL ,[filter] [int] NOT NULL ,[filter_clause] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[ins_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[name] [sysname] NOT NULL ,[objid] [int] NOT NULL ,[pubid] [int] NOT NULL ,[pre_creation_cmd] [tinyint] NOT NULL ,[status] [tinyint] NOT NULL ,[sync_objid] [int] NOT NULL ,[type] [tinyint] NOT NULL ,[upd_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[schema_option] [binary] (8) NULL ,[dest_owner] [sysname] NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysschemaarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [dbo].[sysschemaarticles]GOCREATE TABLE [dbo].[sysschemaarticles] ([artid] [int] NOT NULL ,[creation_script] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL,[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[dest_object] [sysname] NOT NULL ,[name] [sysname] NOT NULL ,[objid] [int] NOT NULL ,[pubid] [int] NOT NULL ,[pre_creation_cmd] [tinyint] NOT NULL ,[status] [int] NOT NULL ,[type] [tinyint] NOT NULL ,[schema_option] [binary] (8) NULL ,[dest_owner] [sysname] NULL) ON [PRIMARY]GOdeclare @dbname varchar(130)select @dbname ='sp_replicationdboption'+char(39)+db_name()+char(39)+',''merge publish'',''false'''exec (@dbname)select @dbname ='sp_replicationdboption'+char(39)+db_name()+char(39)+',''publish'',''fals e'''exec (@dbname)reconfigure with overridegoselect db_name()</code>Can any one please help me as this is a production machine and needsfixing ASAP.Regards,Ben
View Replies !
No Services Installed With SQL Server 2005 Enterprise On Windows XP SP2
Hello, I started out with SQLExpress and that installed just fine. After going through some books about SQL, I found out the limitations to SQLExpress and realized that I would need the full version if I was to further my education on this. (analysis services, integration services, etc etc.) I uninstalled SQLExpress and downloaded and installed SQL Server 2005 (Enterprise Edition I believe). I have installed SQL Server 2005 and I went to go connect. It says it requires a Server Name. So I put the local name of the computer in there and came back with an Error 40. During the troubleshooting of what is causing this error I discovered there are no Services installed from SQL Server 2005. They were removed when I removed SQLExpress and not reinstalled when I installed SQL Server 2005. I checked in both the Services Icon in Administrative Tools and in the SQL Server Configuration Manager. This would account for my not being able to connect to a local server. How do I bring them back. I have uninstalled and reinstalled SQL Server 2005 3 times now. It doesn't bring them back. Now, apparently Enterprise edition does not run on Windows XP Pro SP2. Is there anyway around this? I heard something about a manual installation from the CD but I didn't understand what he was attempting to say. http://www.dbtalk.net/microsoft-public-sqlserver-setup/no-services-components-installed-292167.html Thanks, Wayne
View Replies !
Problem To Install SQL Server 2005 Enterprise Edition 64 Bits On A Cluster With 4 Nodes, With Sql Server 2000 Already Installed
Hi i tray to install a new Virtual SQL Server independent for a SQL Server already installed and when the setup comes to install SQL Server Database commponets it fails, because tray to install on a drive that is not part of the new gruop resource. This is part of the log. MSI (s) (BC8) [11:26:43:107]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixRS.9754C2F0_FC41_4ADF_9C17_1D45EA972478 property. Its value is 'SQLServer2005ReportServerUser$CIOSAN04$'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixSSIS.9754C2F0_FC41_4ADF_9C17_1D45EA972478 property. Its value is 'SQLServer2005DTSUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005ReportServerUser$CIOSAN04$'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005DTSUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'CIOSAN04SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'CIOSAN04SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'CIOSAN04SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupADHelper.4695FFBD_7951_480B_8B19_2D6E3E1CF9A6 property. Its value is 'SQLServer2005MSSQLServerADHelperUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupADHelper.4695FFBD_7951_480B_8B19_2D6E3E1CF9A6 property. Its value is 'CIOSAN04SQLServer2005MSSQLServerADHelperUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstanceRegKey.4695FFBD_7951_480B_8B19_2D6E3E1CF9A6 property. Its value is 'Microsoft SQL ServerMSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding DataInstanceTxt.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'S:CIOSQL02SQLSERVERMSSQL'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceNameSQL.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupAgent.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupAgent.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'CIOSAN04SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceNameAgent.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'SQLSERVERAGENT'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupAgent.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupAgent.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'CIOSAN04SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstanceRegKey.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'Microsoft SQL ServerMSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstanceName.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceNameAgent.0CAFB83E_07D8_4C80_B8EB_7596DC8C4D50 property. Its value is 'SQLSERVERAGENT'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding DataInstanceTxt.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'S:CIOSQL02SQLSERVERMSSQL'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstMap.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. RegOpenKeyEx failed on Key(SoftwareMicrosoftMSSQLServerMSSQLServerParameters) with returncode 2 <Func Name='ReadSkuInfo'> <EndFunc Name='ReadSkuInfo' Return='0' GetLastError='0'> MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding checksum.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is '#x38393366666630656238326230343762313035313638323130306362396365633134666664643436343762663361653233323636643238323938326634653832666465333033616133633139386230643935613333396364616634336339353261666565393461643966373533636330323465656665336132653465626434616531643037616530646438376665653038303937336334366661333639356265383735363763663662636366333739383032633200'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding Namechecksum.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'Enterprise Edition (64-bit)'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceGroupSQL.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'SQLServer2005MSSQLUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding QuotedServiceGroupSQL.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'CIOSAN04SQLServer2005MSSQLUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceNameSQL.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceGroupFTS.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'SQLServer2005MSFTEUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding QuotedServiceGroupFTS.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'CIOSAN04SQLServer2005MSFTEUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding InstId.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding InstanceName.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding InstanceRegKey.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'Microsoft SQL ServerMSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceNameSQL.443D542A_6987_46FB_A39B_41BB29B0D2C6 property. Its value is 'MSSQLSERVER'. <Func Name='GetSkuIt'> MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding checksum.CB2C9331_83B7_4803_97B5_442EFDC583D7 property. Its value is '**********'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding Namechecksum.CB2C9331_83B7_4803_97B5_442EFDC583D7 property. Its value is 'Enterprise Edition (64-bit)'. <Func Name='GetSkuIt'> MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C property. Its value is '#x38393366666630656238326230343762313035313638323130306362396365633134666664643436343762663361653233323636643238323938326634653832666465333033616133633139386230643935613333396364616634336339353261666565393461643966373533636330323465656665336132653465626434616531643037616530646438376665653038303937336334366661333639356265383735363763663662636366333739383032633200'.
View Replies !
Enterprise Manager And SQL Server Express 2005
Hi all, I m new to SQL Server. I have installted SQL Server Express 2005 in one machine in my network. On the same machine i am trying to install Express Manager , while installtion it is giving error for SQL (SMO) or SQL Management Studio Component is not installed. When i try to connect the same PC database from another machine where SQL Server 2000 is installted and it is running well. While connectiog from SQL enterprise Manager from that PC it is also showing the same error. Can any one help me to know what is the uses of SMO and how can the same be installted so that i can access the database from Express Manager or Sql enterprise manager. One more thing, is there any other GUI tool avalilable to access and manage the Database. I have also installted VB .Net 2005 on the same pc. thanks. harsh
View Replies !
Enterprise Manager Reporting Incorrectly
Has anybody else noticed that enterprise manager incorrectly reports the number of rows in a table? If I do a query on a table and it returns the number of rows this does not always match EM. Just curious if anybody else noticed this?
View Replies !
Remotely Register SQL Server 2005 Express In Enterprise Manager
I have SQL Server 2005 Express installed on a windows server 2003 standard edition. I have configured the windows firewall to allow exceptions for sqlservr.exe and sqlbrowser.exe. I have enabled remote and local connections using tcp/ip & Named Pipes through the Sql Server Surface Area Connection utility. I am able to telnet into the server with: telnet <server ip> <1433>. Here is the strange part: I am able to connect to the Sql Server remotely from a development machine via Sql Server Management Studio Express, but I am unable to connect to the Sql Server from the same development machine by registering it in Sql Server Enterprise Manager...Is it possible to register SQL Express through Enterprise Manager? When registering the SQL Express DB in Enterprise Manager I tried both just the (IP Address) of the server and the (IP AddressSQLExpress) as the server/host but I am getting the following errors from enterprise manager: Just the (IP Address) as the server/host: Invalid Connection. ConnectionOpen( Invalid Instance()) (IP AddressSQLEXPRESS) as the server/host: Sql Server does not exist or access denied. ConnectOpen(Connect()). Any idea why I can€™t register/mount the instance remotely in Enterprise Manager but I can in Sql Server Management Studio Express? Thanks, Greg
View Replies !
SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server. Questions: 1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server? 2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected problems when running both 2000 and 2005 SQL Server at the same database server? 3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade? TIA, Jeffrey
View Replies !
Using MS SQL Server 2005 Enterprise Manager With MS SQL Server 2000
Hi Everyone,Most of our MS SQL Servers are still running on SQL 2000, but being Iwill soon be upgrading my workstation to Vista Business I'd like toinstall MS SQL 2005 Enterprise Manager to manage them all. When Itried to install MS SQL 2000 Enterprise Manager on Vista, it gave me amessage saying it's not compatible, so I'll have to use 2005 I guess.We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EMwork with these okay? Also I want to make sure SQL 2005 EnterpriseManager won't be adding to, changing, or 'upgrading' the DTS scripts oranything on the SQL 2000 servers as we still have folks using SQL 2000Enterprise Manager.Thanks for any suggestions. I'm always leery when using cross-versionsof Microsoft applications because they are often incompatible or theydo squirly things that often break stuff.Thanks --Alex
View Replies !
Windows Server 2008 Enterprise && SQL Server 2005 Express Reporting Services
Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. Whenever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible. Thanks Matthew
View Replies !
Windows Server 2008 Enterprise && SQL Server 2005 Reporting Services
Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. When ever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible. Thanks Matthew
View Replies !
Where Is Enterprise Manager In SQL 2005
Ok I just installed VS 2005 Pro with that it asked me to install SQL 2005 and I said yes. Now I can't find the Enterprise Manager to create a database --weired-- All I see is configuration tools under SQL Server 2005. Am I missing something here? Thanks.
View Replies !
SQL 2005 -- Where Is Enterprise Manager?
I just downloaded SQL 2005 Enterprise Edition and I cannot find Enterprise Manager, which is a feature of SQL 2000. I do not know how to create a database, a table, etc without it. How do I do get enterprise manager. Thanks.
View Replies !
What Happened To Enterprise Manager In SQL 2005?
I just go a new job where I work with Point of Sale machines and I'm having a hard time figuring SQL 2005 out. When I was in school we were taught using SQL 2000. Some of our POS (Point of Sale) machines are moving over to using SQL 2005 Express and I am having the hardest time figuring all this out. All be it I haven't use SQL in a good while but I still remember how to administer SQL 2000 with Enterprise manager. Am I missing something or what's the deal hear. Any help would be much appreciated! Best regards, --Bob Bob McQuay ADI Business Solutions bobm@adionline.com Network Technician
View Replies !
Enterprise Manager For SQL 2005 Express
Hi, Ive received a .bak file of our company db from our hosting company and would like to import it into the SQL 2005 Express machine however, Ive never done this before using 2005. Previously with SQL 2000, I used the enterprise manager to view/import data into the database but Im unable to find this feature with 2005. Can anyone help me? Thanks DW
View Replies !
Configure IIS For Reporting Manager And Reporting Server Site
Dear All: My reporting manager and reporting server were working fine in IIS. But when I booted the system one day, one error message came "Unexpected error" for the IIS. So I removed the IIS and reinstalled he same. But after that, I tried to give virtual directories to reporting manager and reporting server sites. But it ain't working. Could you please help me? My IIS 5.1 Reporting service 2005 Express with SQL Server Express ASP.NET 2.0 Express. Please help. Thanks in Advance Emmanuel Mathew
View Replies !
SQL Server Enterprise Manager
Does SQL Server Enterprise Manager and Query Analyzer come with the MSDE version of SQL Server 2000. If it does, how do I open and access it? If it doesn't, where can I download it from?
View Replies !
Where Is SQL Server Enterprise Manager?
I'm a newbie trying to find the SQL Server Enterprise Manager so I cancreate a database. I have installed SQL Server 2005 Express and SQL ServerManagement Studio Express. On the SQL Server menu I see (1) ConfigurationTools and (2) SQL Server Management Studio Express. The SQL ServerManagement Studio Express menu has 3 items on it. Where do I find theEnterprise Manager?Robert
View Replies !
SQL Server Enterprise Manager
Hi I am encountering a rare situation with the following problem. I have a DTS Package which calls couple of Stored procs to Truncate the tables and referesh the tables with new data. When I execute this DTS package (all by itself) it runs fine and populates the tables with 38000 rows. However when I execute this DTS package using the enterpise manager's Job Scheduler it says completed successfully but will have populated only 3000 rows. (given the user rights are same for scheduler and for running DTS packages; SQL Server: Version 7/ Windows NT Server 4/SQL Serevr Service Pack 3) Any suggestions on why this problem could be occuring will be greatly appreciated. Thanks in advance Ajith
View Replies !
SQL Server Enterprise Manager.MSC
Does anyone know how to recreate the SQL Server Enterprise Manager.MSC file? It seems to have disappeared from the server. How can I open Enterprise Manager without it? I'm using NT4.0 and SQL Server 7. Thanks, Robert
View Replies !
SQL Server Enterprise Manager.MSC
I've managed somehow to corrupt the Enterprise Manager.MSC file (it has ocurred several times), so it's impossible to open a table. What can I do about it except re-installing the server? What can be done to protect this file? Thanks in advance. Asnate
View Replies !
SQL Server 7.0 Enterprise Manager
I'm a newbie to Enterprise Manager so I appreciate any help. Here's my question: I have a SQL Server 7.0 account hosted by a webhosting company on a shared server. When I create a server registration and attempt to connect remotely to this database using Enterprise Manager, I get the following error: Server user "john_sa' is not a valid user in database 'test123497' The problem is that test123497 is NOT the database that they are hosting for me. I rechecked my Client Network Utility alias to make sure I'm connecting to the correct IP address and I double checked my username and password. The server hosting this account is attempting to connect me to the wrong database. Sometimes I get through ok and other times I get the above error. Is this because the hosting company has too many accounts on this server? Is the server running out of resources? Is there anything I can do remotely to control this? Any answers would be greatly appreciated. Thank you, john.
View Replies !
SQL Server Enterprise Manager
I am trying desparately to build a user defined function on the Microsoft SQL Server 2000 viewer and when it is performed I get the following message: [Microsoft][ODB SQL Server Driver][SQL Server] Maximum stored procedure, function, trigger, or view nesting level exceeded Is there any problem using sql MAX() built in function? How can I resolve this issue? The UDF code is: CREATE FUNCTION TestFunc (@Syn int) RETURNS int AS BEGIN IF @Syn IS NULL RETURN 1 DECLARE @NewPersonID INT SELECT @NewPersonID = MAX(PersonID) FROM GO_Test WHERE SynagogueID = @Syn RETURN ISNULL(@NewPersonID + 1, 1) END I call the function from the 'Formula' propery of a computed field of a table like this: ([dbo].[TestFunc]([SynagogueID])) while SynagogueID is a field on the same table.
View Replies !
Sql Server Enterprise Manager
I have a AS400 that I retrieved data from and imported into SQL 2000 Server. However, the data will only insert 1 time. I would like to query the AS400 every minutes to update my table on SQL server. If the data is already in my table it does not get updated. How can I get updated/changed data every 15 minutes? HELP!!!!! Lisa Jefferson
View Replies !
Server Enterprise Manager
Why does the SQL Server Enterprise Manager seem to block other processes? I am working with SQL2000 developers version with SP4. When I set up a Data transformation service, it is not actioned until I close/open the Server Enterprise Manager. Otherwise it sits there as Process id 51 Master - runnable (this is the SEM) and Process id 52 - DTS sleeping. Nigel Phact
View Replies !
Upgrading Reporting Services 2005 Standard To Enterprise
I was trying to upgrade 2005 reporting services from standard edition to enterprise..But is's exiting with below error. I am using the below command to start upgrade. ..Please shed some light. start /wait setup.exe ADDLOCAL=RS_Server INSTANCENAME=MSSQLSERVER UPGRADE=RS_Server SKUUPGRADE=1 Error: Running: ReportChainingResults at: 2007/10/23 11:2:46 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : -2147024809 Error Code: -2147024809 Windows Error Text: The parameter is incorrect. Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Nov 16 20:31:57 2006 Function Name: sqls::ReportChainingResults:erform Source Line Number: 3521 Thanks, Kris.
View Replies !
Server Explorer (VS.NET) Vs. Enterprise Manager
Hello,I'm having the following dilemma: I'm trying to connect to a database on a SQL Server, somewhere else in the country. - With Server Explorer in VS.Net it is no problem at all. New dataconnection: i fill in the ip-adress, user and pass, and the database-name i want to connect to, and voila, it's done. I can add, edit, delete everything.- With enterprise manager: With enterprise manager i can make a connection with the server, but after that the database isn't visible. And as far as i know i can't connect to a certain database. Another option i tried is to create a linked server on my local server: that does work, only now i can't add/edit/delete..I really want to work with enterprise manager, but is there any way to connect to one db only, and still be able to add/edit/delete ?? I can't find the solution..Please help..Much regards..J.JansmaThe netherlands
View Replies !
Regd SQl Server Enterprise Manager
Hi,i would like to know - when we register a sql server (2000 in my case)in the enterprise manager from where does this information (name of theserver) come from? i.e where is this information stored ?thanks for the help.Regards,Shark.
View Replies !
Enterprise Manager Crashing SQL Server
Hi We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables. Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied. However our enterprise manager clients are registered with SA so I dont think that is an issue. Can anyone give me some help with this and/or direct me to the hotfix please. Cheers Louise
View Replies !
Server Status In Enterprise Manager
I have 15+ servers registered and all but one display the current status of the server - i.e. running, stopped etc. Every time I expand the one server I get the error " the server is not known to be running..." if I answer yes to connect anyway, I'm able to connect and all seems well. What's causing this? And yes, the client is setup to poll the server at 10 second intervals. Thanks in advance.
View Replies !
SQL Server Enterprise Manager Error
when i try to view all rows of any of my tables through sql server enterprise manager i get the following error can anyone tell me why.An unexpected error happened during this operation [Query]-Query designer encountered a query error-unspecified error.I am using sql server 7.0. Thanks Ann
View Replies !
|
TRACKER
