Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    3

    Unanswered: 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,
    Jaidev

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The error reflects missing .dll files on the machine, uninstall and reinstall again.

    BTW< what is the service pack level on OS?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Posts
    3

    found the problem...

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •