Dec 6, 2006
when i was installing ss2005 i got two warnings:
- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
I-IS Feature Requirement (Warning)
Messages
IIS Feature Requirement
then in the next step ,there was only one option i could choose(workstation components,books online and develop tools), all the services were grey and not selected ,here 's the log file
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Professional (Build 6000)
Time : Wed Dec 06 13:01:54 2006
TJM-PC : The current system does not meet the minimum hardware requirements for this SQL Server release. For system requirements, see Hardware and Software Requirements, in the readme file or in SQL Server Books Online.
TJM-PC : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Machine : TJM-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU
Product Version : 8.0.50727.42
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_PPESku_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_OWC11_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BOL_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLXML4_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server 2005 Tools
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_Tools.log
--------------------------------------------------------------------------------
could any one tell my how could i intall the sql server database services and other services?
thanks
View 6 Replies
View Related
Sep 20, 2007
While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows...
Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007
Process ID : 5440
E:setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/8/20 11:11:35
Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35
Loaded DLL:E:xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/8/20 11:11:35
Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true
Running: ValidateMinOSAction at: 2007/8/20 11:11:35
Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true
Running: PerformSCCAction at: 2007/8/20 11:11:35
Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true
Running: ActivateLoggingAction at: 2007/8/20 11:11:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
Any ideas?
Thanks in advance.
View 1 Replies
View Related
Dec 3, 2006
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 2 Replies
View Related
Feb 12, 2004
hi,
i'm running win2k sp4 on a 2.4Ghz P4 with 512M ram and 1.5 gigs freespace on my harddrive (more than enough for the sql server client).
i insert the cd and start up the installer. i then get the splash screen, click on "SQL Server 2000 Components", then on "Install Database Server". Then the splash screen disappears and nothing happens for a while (sometimes a really long while). Then an error message pops up saying:
Setup initialization error.
<some message>
Source: 'E:<some source>'
Target: 'C:WINNTTEMPSqlSetup<some target>'
where <some message> is a differing message. sometimes it's "The data is invalid", sometimes a cycle redundancy check error, sometimes a inpage error...
<some source> is one of the files on the sql server cd, and this also differs most of the time.
<some target> is the corresponding <some source> in the sql server setup's temp dir.
as well, if i restart my computer and try starting the installer after windows has started up (well, at least all of the sys tray icons have loaded) i usually get an error message saying something about "msetup" having an error and being shut down. it also mentions that there is some log file which is created, but i'm not sure where it's located or what it's called.
i have also noticed that some process called " wowexec.exe" is starts up when the installer does, and keeps running after the installer (setupsql.exe) crashes. i am also unable to end the " wowexec.exe" process and process tree.
i don't think there's anything wrong with the cd, since it looks like it works file on other pc's. any idea what may be wrong?
i would really appreciate any help in fixing this. i really need to get the sql server 2k client installed (particularly the enterprise manager).
tia
View 4 Replies
View Related
