Error installing SQL 2000

  • Hi all,

    I was reinstalling SQL 2000 but at the end I received a message that shows "Setup failed to configure the server.   Refer to the server error logs and C:\WINNT\sqlstp.log for more information"

    I was looking at this file but I don't find the reason because the installation is failing.

    I include the las part of this file "sqlstp.log":

    Starting Service ...

    Modern_Spanish_CS_AS

    -m -Q -T4022 -T3659

    Connecting to Server ...

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

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

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

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

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

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

    SQL Server configuration failed.

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

    16:20:49 Process Exit Code: (-1)

    16:21:07 Setup failed to configure the server.   Refer to the server error logs and C:\WINNT\sqlstp.log for more information.

    16:21:07 Action CleanUpInstall:

    16:21:07 C:\DOCUME~1\SUPERV~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service SQLSERVERAGENT

    16:21:07 Process Exit Code: (1060) The specified service does not exist as an installed service.

    16:21:07 C:\DOCUME~1\SUPERV~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER

    16:21:07 Process Exit Code: (0)

    16:21:07 StatsGenerate returned: 2

    16:21:07 StatsGenerate (0x0,0x1,0xf00,0x100,1033,303,0x0,0x1,0,0,0

    16:21:07 StatsGenerate -1,supervisor)

    16:21:07 Installation Failed.

    I deleted all files about SQL folder but it happens again. I don't know if I can delete something in the registry and like this to can install it.

    Someone knows anything about this?

    Any suggestion will be appreciate.

    Thanks

  • Can you give me some background on what happened to this server that you need to re-install SQL Server?  I would recommend first un-installing SQL Server and doing a fresh install as opposed to attempting to re-install over the top of an existing SQL Server instance.  This may sound silly, but are you performing the install using a local admin account? 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • I installed SQL Server and Analisys Services and later I un-install Analisys Services. When I wanted to connect to the server from EM, it's was imposible. The MSSQLServer service is started but I can't work with EM.

    Then, I decided un-install SQL Server too and to install it again from fresh install. I have tried it twice.

    All installation process is good but at the end of the process is showed the error message.

    I saw into the sqlstp.log file two things:

    • Data source name not found and no default driver specified
    • The specified service does not exist as an installed service.

    About rights... yes, the account is local admin.

    Thanks for your help.

  • 1. Please go to Control Panel => ODBC Administrator and check that you have SQL Driver listed

    2. If not, download component checker from support.microsoft.com and check MDAC dll versions

    3. If there are mismatches, apply proper MDAC Service pack.

    4. I am available at bmlakhani@yahoo.com feel free to ping me in next 2 hour.

     

     

  • In the Control Panel I haven't SQL driver.

    I run component checker but it shows the message "The following products releases were matched: UNKNOWN"

    After, I have installed MDAC 2.7.1 but in the Control Panel didn`t appear anything.

    I did a test. I installed Connectivity only in SQL Server and this option was installed success and I can open "Client Network Utility". In the Control Panel doesn't appear anything in Drivers tab.

    Now, I will try to install again SQL Server.

    I told you the results.

    Thanks

  • lets do this.

    Delete below key from Registry (please take backup) and reinstall MDAC

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents

    Reinstall MDAC and run component checker again

     

     

  • I can't delete this value.

    I received the message "Unable to delete all specified values"

    The value into this key is :

    • Name: Default
    • Type: REG_SZ
    • Data: (value not set)

    I tested to delete all key (included the ExceptionComponent folder) and I could, but I exported again (I think you told me that I delete only the value of the key and not the folder.)

     

  • You wil find many GUID (Long numbers; something like {DD90D410-1823-43EB-9A16-A2331BF08799}) under that key.

    Please try deleting them and reinstall MDAC

     

  • Only there is the value that I told you.

    There aren't anymore.

  • Is there any driver listed in ODBC Administartor??

  • No.

    There aren't any drivers listed in ODBC. I think is very strange. I have W2003 SP1 installed.

  • That's interesting

    Download a tool from below link and run it

    http://www.betav.com/Files/Content/Tools/tools.htm

    Download mdacrt.exe from there any Run it. You should see drivers listed there after this...

    Once you see drivers listed there, then Try running Setup.

    Let me know results 

     

  • Although I saw in the web that the tool was for W2000, I did a registry backup and I run the MDAC repair.

    After I take a look into ODBC Administrator and, surprise, I had severals drivers installed. One of then was SQL Server.

    Then I installed again SQL Server and now all has been success.

    Note: I looked at the registry key (HKLM\...\...\CurrentVersion\Setup\ExceptionComponents) for curiosity and the value is the same. I don't know whether that is good or bad. Besides, I re-run again component checker and I received the same error message "UNKNOWN".

    I think the most important is that I could install the application. I hope in a next future that I haven't errors in the server.

    Many thanks for your help.

     

  • Nice to hear that issue is resolved by solution provided by me.

    I have no idea why Component Checker returns unknown.

    If you need any help in that, I need to do some research. Let me know if you need reason for this.

     

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply