Post reply

Installing SQL server 2000 on Windows 2003 Server

  • August 3, 2003 at 5:23 am

    #82935

    I had a problem to install SQL Server 2000 on a Windows 2003 server cluster.

    First the installation told me that this windows version supports only SQL Server 2000 with SP2 and above. I asked to continue at this stage.

    Then, after filling oll the details for the installation, it told me that it could not perform the required action (this is not the exact message).

    (This is not 64-bit windows 2003 server)

    Any idea?

  • August 3, 2003 at 6:02 am

    #468336

    You're not trying to install on Win 2003 Beta, or the Web Edition are you? There's issues/restrictions with them.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 3, 2003 at 10:12 am

    #468339

    I'm trying to install on Windows 2003 Server Enterprise edition (not the beta edition or the web edition)

  • August 3, 2003 at 3:06 pm

    #468344

    oh well, scratch that theory.

    anything in the setup log/s?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 3, 2003 at 6:33 pm

    #468354

    Hi,

    I believe is the SQL server installation problem as originally the SQL server does not came with any SP.

    Try search around M$ site and hopefully may get some ideas.

    Regards,

    Andy


    Regards,

    Andy

  • August 4, 2003 at 1:06 am

    #468371

    Just wnated to say thanks for the fast replies. I'll try to get some more information and get back to you.

    Thanks a lot,

    Oded

  • August 4, 2003 at 2:04 am

    #468376

    This is quite easily resolved.

    Just ignore the messages then apply the latest service pack to SQL server. Everything should work (it works for me anyway). Standard and Enterprise both run SQL server quite happily. As for Web Edition - I've never got it to install.

  • August 4, 2003 at 7:27 am

    #468424

    As Pinhead said, ignore the message and install SP3 as soon as possible. For additional information, please see KB article 329329 "Windows Server 2003 Support for SQL Server 2000".

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;329329

  • August 4, 2003 at 9:27 am

    #468455

    The second error is what's important here. The SP2 message that is initially encounter is merely a warning message and upon completing the install, apply SP3 and you should be fine. We ran into the same install problem while testing our cluster with Win2k3 and SQL 2k. The error message was "Setup failed to perform the required operation on the cluster nodes." when attempting to install SQL server. After extensive troubleshooting on our end we finally called Microsoft. Apparently there is a known problem with the SQL2k installer that is incompatible with Win2k3 clusters when terminal services is installed. You can use Remote Desktop instead of Terminal Services so that you don't lose any functionality. Cindy from the Microsoft SQL server group that helped us was great. She knew exactly what our issue was and tested it in the lab to verify it too. Here is our case notes (Knowledge Base article 318672 or Q318672)...

    -Steve Cabiness

    Database Administrator

    InSight Health Corp.

    ACTION:

    You are installing a clustered instance of SQL Server 2000 on Windows Server 2003.

    RESULT:

    It fails with "Setup failed to perform required operations on the cluster nodes." The sqlstp.log file contains:

    13:32:18 Setup is performing required operations on cluster nodes. This may take a few minutes...

    13:32:18 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\Documents and Settings\TEMP\WINDOWS\remsetup.ini

    13:32:18 Process Exit Code: (-1)

    13:32:18 Begin Action : GetRemsetupRetCode

    13:32:18 Installation return status on IHSC1CLS1 : -1

    13:32:18 End Action : GetRemsetupRetCode

    13:32:18 End Action : Run setup on cluster nodes

    13:32:18 One or more errors occurred while running remote setup on the clustered machines.

    13:32:20 Setup failed to perform required operations on the cluster nodes.

    CAUSE:

    The Windows Server 2003-based computer that has Terminal Services installed causes the SQL Server 2000 Setup to try to copy files to the Windows folder of the user who is currently logged on instead of the Windows (%SystemRoot%) folder. In Windows 2003 there is no "application mode vs. admin mode". Terminal services is either installed or not (and is in what used to be called application mode). While the remote desktop option uses terminal services technology, it is not dependent on terminal services being installed and does not affect the installation of SQL Server 2000.

    RESOLUTION:

    Uninstall terminal services from the Windows Server 2003 cluster, then retry the SQL Server 2000 installation.

  • August 4, 2003 at 4:08 pm

    #468547

    The terminal services problem seems to be it. I did install terminal services on both of the cluster nodes.

    I'll try to uninstall it and then install SQL 2k.

    Thanks,

    Oded

  • August 5, 2003 at 2:09 pm

    #468724

    yes,,,, badness, MS has posted it.

    Win 2003 can only accept SQL server at sp3.

    THERE IS NO EXISTING SQL SERVER MEDIA THAT INSTALLS AT SP3 !!! chicken, or the egg ?

    UPGRADE 2000 server to 2003 server after applying SP3

  • August 5, 2003 at 3:05 pm

    #468735

    install ignore errors apply sp3 after install. I do belive that was the answer given.

    Wes

  • August 13, 2003 at 9:46 am

    #469778

    Try checking aritcle (815431) on Microsofts site to work around the issue. It worked for me.

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

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