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

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

Method 1

For Windows Server 2003 32-bit editions, use Client Network Utility (CNU) to create a named pipes alias.

Before you install a named instance of SQL Server 2000 virtual server, use 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.

Method 2

When you install a 32-bit edition of SQL Server 2000 on a 64-bit edition of Windows Server 2003, follow these steps:

1. On the node where you want to run the SQL Server Setup program, click Start, click Run, type RegEdit, and then click OK.
   
2. Locate and then right-click the following registry subkey:
   
   HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo
3. Point to New, and then click String Value. A new registry entry is created.
   
4. Type the following name for the newly created registry entry:
   
   VirtualServerName\InstanceName
   Note VirtualServerName is a placeholder for the name of the virtual server. InstanceName is a placeholder for the name of the named instance of SQL Server 2000.
   
5. Right-click the newly created registry entry, and then click Modify.
   
6. In the Edit String dialog box, paste the following text in the Value Data box:
   
   DBNMPNTW,\\VirtualServerName\pipe\MSSQL$InstanceName\sql\query
7. Click OK.
8. Exit Registry Editor.