Hi,
I am trying to install sql server 2000 on a XP m/c and get the following error at the end:
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
The log file has the following:
13:19:05 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 787004 -U sa -P
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
################################################## #############################
13:19:33 Process Exit Code: (-1)
13:19:36 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
13:19:36 Action CleanUpInstall:
13:19:36 C:\DOCUME~1\jd_deepa\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
13:19:36 Process Exit Code: (1060) The specified service does not exist as an installed service.
13:19:36 C:\DOCUME~1\jd_deepa\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service MSSQLSERVER
13:19:36 Process Exit Code: (0)
13:19:36 StatsGenerate returned: 2
13:19:36 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
13:19:36 StatsGenerate -1,jd_deepa)
13:19:36 Installation Failed.
Any help will be greatly appreciated.
Thanks a lot in advance,
JaidevThe error reflects missing .dll files on the machine, uninstall and reinstall again.
BTW< what is the service pack level on OS?|||Thanks a lot guys. The problem was that for whatever weird reason, there was no entry in the registry for the sql server driver under HKLM\SOFTWARE\ODBC. I created the entry manually and then reinstalled SQL server successfully.
Any idea why the installer did not create these entries?
Actually, I could create a new instance successfully. But my default instance seems to be screwed. I cannot uninstall the default instance nor does reinstalling works. So on a different note, Any idea how I can uninstall this (manually) default instance ?
Thanks,
Jaidev
No comments:
Post a Comment