Installation of a named instance of SQL Server 2000 virtual server on a Windows Server 2003-based cluster fails (815431)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions), when used with:
    • Microsoft Windows Server 2003, Enterprise Edition
    • Microsoft Windows Server 2003, Datacenter Edition

SYMPTOMS

When you install a named instance of Microsoft SQL Server 2000 virtual server on a computer that is running Microsoft Windows Server 2003, Enterprise Edition or Microsoft Windows Server 2003, Datacenter Edition, the following behavior occurs:
  • Setup stops responding.
  • You receive the following error message:
    The cluster resource failed to come online. If extended error information was reported by the clustering service it can be obtained from the event log.
  • The following text is logged in the Sqlstp.log file in the Windows folder:
    12:00:42 End Action : CreateVirtualServerResources
    12:12:05 The cluster resource failed to come online. If extended error information was reported by the clustering service it can be obtained from the event log.
  • The following error message is logged in the SQL Server virtual server Setup file (Sqlclstr.log):
    00000750.00000190::2003/02/05-02:34:50.387 ERR SQL Server <SQL Server (ONE)>: [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
    00000750.00000dd8::2003/02/05-02:34:51.470 WARN [RM] RmpTimerThread: Resource SQL Server (ONE) pending timed out, CP 0 - setting state to failed.
  • You may receive an Appshelp error message that is similar to the following:
    The version of SQL Server 2000 you are running has known security vulnerabilities with Windows Server 2003. To prevent virus and work attacks, the TCP/IP and UDP network ports are disabled. Please install a patch or upgrade your service pack to make your server more secure.

CAUSE

To run SQL Server on Windows Server 2003, you must have SQL Server 2000 Service Pack 3 (SP3) installed. Windows Server 2003 blocks TCP/IP functionality for named instances that are not running SQL Server 2000 SP3 or later. In SQL Server 2000 virtual server Setup, SQL Server resources are created and brought online. To bring a resource online, a lightweight connection is made to the computer that is running SQL Server by using the SQL Server resource DLL (Sqsrvres.dll or Sqagtres.dll). The connection request fails because of the blocked TCP/IP functionality. This behavior causes Setup to stop responding.

WORKAROUND

To get to the supported configuration of SQL Server 2000 SP3 on a Windows Server 2003-based computer, use the following method:

Use Client Network Utility to create a named pipes alias

Before you install a named instance of SQL Server 2000 virtual server, use Client Network Utility (CNU) to create a server alias to make a connection over named pipes (during Setup) while creating and bringing the SQL Server resources Online. Repeat this process for each named instance installation.
  1. From the node where you want to run Setup, create a server alias for the client connection:
    1. Run Cliconfg.exe on the cluster node where you will run Setup.

      Note If Cliconfg.exe is not installed on your computer, install it by running Sqlredis.exe from the SQL Server 2000 installation files. To do this, type the following information at a command prompt:

      \x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"

      You may have to restart your computer if Cliconfg.exe is not immediately available. For more information about SQL Server 2000 Setup, click the following article number to view the article in the Microsoft Knowledge Base:

      257716 Frequently asked questions - SQL Server 2000 - Setup

    2. In the SQL Server Client Network Utility dialog box, click the Alias tab.
    3. Click Add to open the Add Network Library Configuration dialog box.
    4. Click to select the Named Pipes check box.
    5. Type the alias name in the Server alias box. For example, type the following: VIRTUALSERVERNAME\INSTANCENAME.
    6. Type the virtual server instance name in Server name box. For example, type the following: VIRTUALSERVERNAME\INSTANCENAME.
    7. Verify the name in the Pipe name box. By, default, the value in the Pipe name box is:

      \\VIRTUALSERVERNAME\pipe\MSSQL$instancename\sql\query

  2. Run SQL Server 2000 Setup.
  3. For the virtual server name, use the same virtual server name and instance name that you used in steps 1e and 1f.
  4. Run SQL Server 2000 SP3 Setup.
  5. Remove the named pipes alias that you created in step 1.

REFERENCES

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

811168 SQL Server 2000 Service Pack 3, Service Pack 3a, or Service Pack 4 pre-installation checklist for SQL Server 2000 virtual server for failover clustering

321063 How to troubleshoot the "Setup failed to perform required operations on the cluster nodes" error

To see the SQL Server 2000 SP3 Readme file, visit the following Microsoft Web sites:

http://support.microsoft.com/kb/889551

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

330022 SQL Server 2000 Service Pack 3 Readme.htm additions

290211 How to obtain the latest SQL Server 2000 service pack


329329 Windows Server 2003 support for SQL Server 2000

Modification Type:MajorLast Reviewed:8/7/2006
Keywords:kbSysAdmin kbsetup kbprb kberrmsg kbClustering KB815431 kbAudITPRO kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.