How to change the TCP port that SharePoint Portal Server 2003 uses to connect to SQL Server 2000 (889647)

MORE INFORMATION

Before you use one of the following methods, Client Network Utility must be installed on the computers in your server farm that are running SharePoint Portal Server 2003. For more information about how to install Client Network Utility, visit the following Microsoft Web site:

Method 1: Use Client Network Utility to specify the TCP port that SharePoint Portal Server 2003 uses to connect to SQL Server 2000

Use Client Network Utility to specify the TCP port, and then restart Microsoft Internet Information Services (IIS) 6.0. Follow these steps for each computer in your server farm that is running SharePoint Portal Server 2003. To do this, follow these steps:

1. Specify the port that you want to use. To do this, follow these steps:
   1. Start Client Network Utility.
   2. Click the General tab, click TCP/IP in the Enabled protocols by order box, and then click Properties.
   3. Specify the port number that you want in the Default port box, and then click OK two times.
2. Restart IIS. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.

Method 2: Use Client Network Utility to add an alias and to specify the TCP port that SharePoint Portal Server 2003 uses to connect to SQL Server 2000

Use Client Network Utility to add an alias and to specify a TCP port for the new alias. Follow these steps for each computer in your server farm that is running SharePoint Portal Server 2003. To do this, follow these steps:

1. Install the hotfix package that is described in the following Microsoft Knowledge Base article on a computer in your server farm that is running SharePoint Portal Server 2003:

   885263 Description of the SharePoint Portal Server 2003 post-Service Pack 1 Hotfix Package: September 30, 2004

   Note This hotfix package enables SharePoint Portal Serer 2003 to correctly process alias information that is configured in Client Network Utility.
2. Add an alias and specify the port for the alias. To do this, follow these steps:
   1. Start Client Network Utility.
   2. Click the Alias tab, and then click Add.
   3. Type an alias in the Server alias box, and then click TCP/IP under Network libraries.
   4. Click to clear the Dynamically determine port check box, type the port number that you want in the Port number box, and then click OK two times.
3. Restart IIS. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.

Notes

• If you do not install the hotfix package that is described in article 885263 in the Microsoft Knowledge Base, this method requires that User Datagram Protocol (UDP) port 1434 remain open.
• If you move the SharePoint Portal Server 2003 databases to another computer that is running SQL Server 2000, you may receive an error message that is similar to the following when you try to access the portal site:
  Array cannot be null.
  Parameter name: Source
  For example, you receive this error message when you click the link that is displayed on the Web Parts Maintenance page. This error message may not be caused by a Web Part issue. You may receive this error message in situations when the TCP port that SQL Server 2000 uses is different from the TCP port that SQL Server 2000 used on the original computer. Use Client Network Utility to verify that the port that SQL Server 2000 uses is correct.