RE: SQL 2K fails during install

From: Hemant K (anonymous_at_discussions.microsoft.com)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 13:38:44 -0700

Hi Vikram,

I am attaching the error log. Please review it and let me
know what is the problem. I had disabled all anti-virus
software and personal firewall software and tried to re-
install , I am getting the same error.

08:19:29 End Action: Locked Connectivity Files Check
08:19:29 Setup is installing Microsoft Data Access
Components (MDAC) ...
08:19:29 D:\x86\Other\sqlredis.exe /q:a /C:"setupre.exe
WARN=1 -s -SMS"
08:20:00 ExitCode: 0
08:20:00 Setup is installing Microsoft Distributed
Transaction Coordinator (MSDTC) ...
08:20:00 C:\DOCUME~1\ADMINI~1\LOCALS~1
\Temp\SqlSetup\Bin\cldtcstp.exe -SupportDir "C:\DOCUME~1
\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin" -DTCPkg "D:\x86
\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log"
08:20:01 Process Exit Code: (0)
08:20:01 /Q:A /T:C:\DOCUME~1\ADMINI~1\LOCALS~1
\Temp\ixp001.tmp
08:20:01 Setup is installing HTML Help ...
08:20:05 HTML Help installer exit code: 0
08:20:29 End Action InstallPkgs
08:20:29 Begin Action MoveFileData:
08:20:29 Enabled SELFREGISTERBATCH
08:20:29 Enabled CORECOMPONENTHANDLING
08:22:43 Begin Action: MoveFileDataSpecial
08:22:44 End Action: MoveFileDataSpecial
08:22:44 End Action MoveFileData
08:22:44 Begin Action ProcessAfterDataMove:
08:22:44 D:\x86\Binn\hhcol.exe C:\Program Files\Microsoft
SQL Server\80\Tools\Books
08:22:48 End Action ProcessAfterDataMove
08:22:48 Begin Action BuildServer:
08:22:48 C:\DOCUME~1\ADMINI~1\LOCALS~1
\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -
ExePath "C:\Program Files\Microsoft SQL
Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
08:22:49 Process Exit Code: (0)
08:22:49 Begin Action: CreateRegistrySetSQL
08:22:49 End Action: CreateRegistrySetSQL
08:22:49 Begin Action: RegWriteSetupEntry
08:22:49 End Action: RegWriteSetupEntry
08:22:49 Begin Action: CreateSer
08:22:49 End Action: CreateSer
08:22:49 Begin Action: SkuIt
08:22:49 End Action: SkuIt
08:22:49 SetFileSecuritySQLAndAdmin for C:\Program
Files\Microsoft SQL Server\MSSQL returned: 0, 0
08:22:49 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
08:22:49 Begin Action: UpdateSystemPath
08:22:49 Error - Unable to update path variable -
RegDBGetKeyValueEx
08:22:49
08:22:49 End Action: UpdateSystemPath
08:22:49 Grant Right for SURABHI\Administrator returned :
1, 0
08:22:50 Grant Right for SURABHI\Administrator returned :
1, 0
08:22:50 Grant Right for SURABHI\Administrator returned :
1, 0
08:22:50 Grant Right for SURABHI\Administrator returned :
1, 0
08:22:51 C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I
MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -
H 66290 -U sa -P
##########################################################
#####################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql
server};server=SURABHI;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

driver={sql
server};server=SURABHI;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

driver={sql
server};server=SURABHI;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

SQL Server configuration failed.

##########################################################
#####################

08:23:24 Process Exit Code: (-1)
08:23:31 Setup failed to configure the server. Refer to
the server error logs and C:\WINDOWS\sqlstp.log for more
information.
08:23:35 Action CleanUpInstall:
08:23:35 C:\DOCUME~1\ADMINI~1\LOCALS~1
\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
SQLSERVERAGENT
08:23:35 Process Exit Code: (1060) The specified service
does not exist as an installed service.

08:23:35 C:\DOCUME~1\ADMINI~1\LOCALS~1
\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service
MSSQLSERVER
08:23:35 Process Exit Code: (0)
08:23:35 StatsGenerate returned: 2
08:23:35 StatsGenerate
(0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
08:23:35 StatsGenerate -1,Administrator)
08:23:35 Installation Failed.

>-----Original Message-----
>
>Sir,
>
>Please refer to your sqlstp.log for exact error message.
As a best
>practice, we recommend taht we turn off all 3rd party
and non-essential
>services (inc. anti Virus software) during an install or
an upgrade of SQL
>Server.
>
>Some processes that we know dont interfere with
installation are:
>
>Services -
>Alerter
>ClipBook Server
>Computer Browser
>Directory Replicator
>Event Log Messenger
>Net Logon
>Network DDE
>Network DDE DSDM
>NT LM Security Support Provider
>Remote Procedure Call (RPC) Locator
>Remote Procedure Call (RPC) Service
>Schedule
>Server
>Spooler
>UPS
>Workstation
>
>Processes
>csrss.exe, Explorer.exe, llssrv.exe, loadwc.exe,
lsass.exe, nddeagnt.exe,
>pstores.exe, RpcSs.exe, services.exe, smss.exe,
spools.exe, System, System
>Idle Process, taskmgr.exe, winlogon.exe
>
>Cheers!
>
>Vikram Jayaram
>Microsoft, SQL Server
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>
>.
>

Relevant Pages