Sunday, February 19, 2012

installation failed on XP pro

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