Post reply

Installing SQL Server 2000 Error. Currently had SQL Server 2005 installed....

  • February 22, 2006 at 4:18 pm

    #171242

    Hi all,

    is it possible to run both instances of SQL Server 2000 and 2005 on the same PC?

    The reason I am asking is becasue my install failed for SQL Server 2000 when i already have SQL server 2005 installed.

    Get the following at the end of the sqlstp.log file...

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

    Starting Service ...

    Latin1_General_CI_AS

    -m -Q -T4022 -T3659

    An error occurred while attempting to start the service (1053)

    SQL Server configuration failed.

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

    01:52:54 Process Exit Code: (-1)

    01:54:55 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.

    01:54:55 Action CleanUpInstall:

    01:54:55 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT

    01:54:55 Process Exit Code: (1060) The specified service does not exist as an installed service.

    01:54:55 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER

    01:55:10 Action Exit Handler:

    01:55:12 Process Exit Code: (0)

    01:55:12 StatsGenerate returned: 2

    01:55:12 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0

    01:55:12 StatsGenerate -1,Trystan Hughes)

    01:55:12 Installation Failed.

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

    I'm really stumped by this, and can only think that the reason is because I had SQL Server 2005 installed, but I could be wrong.

    Hope you can help.

    Thanks

    Tryst

  • February 24, 2006 at 7:44 am

    #623209

    It is  supported to run both instances of SQL Server 2000 and 2005 on the same PC. But you need to install 2000 first and then install a named instance of 2005.

    Never tried to install 2005 then 2000. Not sure your error is caused by this or not

     

  • February 25, 2006 at 6:50 pm

    #623363

    OK, thanks for the reply.

    I will uninstall SQL Server 2005, and then install SQL Server 2000 and 2005 respectively.

    Tryst

  • February 26, 2006 at 12:07 pm

    #623377

    Yeah, that seems to have solved it. I uninstalled SQL Server 2005 and then installed SQL Server 2000 and 2005 respectively, and its all working now.

    Thanks

    Tryst

Viewing 4 posts - 1 through 3 (of 3 total)

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