Cannot install SQL Server 2000??

[jgoodman00]

I am trying to install SQL server 2000 on a brand new server. It is running Windows 2000 server. The first time I tried to install it, it exited with the error of being unable to find 'SQLUNIRL.DLL'. So, I found the file on another computer & copied it into the C:\WINNT folder. This time, it did not error on this file. Instead it errored by merely stating that it could not configure the service. Below is the log file (sqlstp.log) which was created. It said I should refer to this, but I cannot see anything which can be of use in the file...

15:46:06 Begin Action: UpdateSystemPath
15:46:06 Path successfully updated.
15:46:06 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
15:46:06 End Action: UpdateSystemPath
15:46:08 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 131266 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

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

[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).

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

[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).

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

[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).

SQL Server configuration failed.

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

15:46:38 Process Exit Code: (-1)
15:46:43 Setup failed to configure the server. Refer to the server error logs and C:\WINNT\sqlstp.log for more information.
15:46:44 Action CleanUpInstall:
15:46:44 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
15:46:44 Process Exit Code: (1060) The specified service does not exist as an installed service.

15:46:44 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
15:46:44 Process Exit Code: (0)
15:46:44 StatsGenerate returned: 2
15:46:44 StatsGenerate (0x0,0x1,0xf0000000,0x0,1033,303,0x0,0x1,0,0,0
15:46:44 StatsGenerate -1,Administrator)
15:46:44 Installation Failed.



Does anybody know what the possible cause could be?
Do you need a special version of SQL server to run on Win2K Server?


James Goodman

James Goodman

 

[weakpun]

could be worth checking that SQL installed the MDAC correctly/you have the correct MDAC level. If I remember rightly, SQL 2000 needs MDAC 2.6 to run, and should install it. Download the component checker from

http://www.microsoft.com/data/download.htm

and see what you have.

Not sure if this will solve your problem, but it could be worth checking...

 

[jgoodman00]

It seems very strange, but I deleted sqlstp.log, restarted the computer & it installed perfectly.

No idea why though!! James Goodman