Microsoft KB Archive/889647

= How to change the TCP port that SharePoint Portal Server or SharePoint Server uses to connect to SQL Server =

Article ID: 889647

Article Last Modified on 6/13/2007

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003
 * Microsoft Office SharePoint Server 2007
 * Microsoft Windows SharePoint Services 3.0
 * Microsoft Windows SharePoint Services

-



INTRODUCTION
This article contains information about how to change the TCP port that Microsoft Office SharePoint Portal Server 2003 uses to connect to Microsoft SQL Server 2000 and the TCP port that Microsoft Office SharePoint Server 2007 uses to connect to Microsoft SQL Server 2005. By default, both SQL Server 2000 and SQL Server 2005 use TCP port 1433 to listen for requests from clients.

If you configure SQL Server to listen on a different port in a server farm deployment of SharePoint Portal Server 2003 or of SharePoint Server 2007, you must also configure SharePoint Portal Server 2003 or SharePoint Server 2007 to connect to SQL Server by using that same port. This article describes the methods that you can use to perform this task.



SQL Server 2000
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 or SharePoint Server 2007. For more information about how to install Client Network Utility, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/aa197918(SQL.80).aspx

Note Client Network Utility is a tool that you can use to change network protocols and to create network protocol connections to computers that are running SQL Server 2000. For more information about how to use Client Network Utility, see Client Network Utility Help.

Method 1: Use Client Network Utility to specify the TCP port that is used to connect to SQL Server 2000
Use Client Network Utility to specify the TCP port, and then restart Internet Information Services (IIS) 6.0. Do this for each computer in your server farm that is running SharePoint Portal Server 2003. To do this, follow these steps:  Specify the port that you want to use. To do this, follow these steps:  Start Client Network Utility. Click the General tab, click TCP/IP in the Enabled protocols by order box, and then click Properties. Specify the port number that you want in the Default port box, and then click OK two times.  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 is used to connect to SQL Server 2000
Use Client Network Utility to add an alias and to specify a TCP port for the new alias. Do this for each computer in your server farm that is running SharePoint Portal Server 2003. To do this, follow these steps:  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 Server 2003 to correctly process alias information that is configured in Client Network Utility.</li> Add an alias, and then specify the port for the alias. To do this, follow these steps:  Start Client Network Utility.</li> Click the Alias tab, and then click Add.</li> Type an alias in the Server alias box, and then click TCP/IP under Network libraries.</li> 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.</li></ol> </li> Restart IIS. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.</li></ol>

Notes <ul> 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.</li> 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 resembles the following error message when you try to access the portal site:

Array cannot be null.

Parameter name:

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.</li></ul>

Method 1: Use SQL Configuration Manager to specify the TCP port that is used to connect to SQL Server 2005
 Specify the port that you want to use. To do this, follow these steps:  Click Start, point to All Programs, click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.</li> Expand SQL Native Client Configuration, click Client Protocols, and then double-click TCP/IP.</li> <li>Specify the port number that you want in the Default port box, and then click OK.</li> <li>Restart IIS. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.</li></ol> </li></ol>

Method 2: Use SQL Configuration Manager to add an alias and to specify the TCP port that is used to connect to SQL Server 2005
<ol> <li>Specify the port that you want to use. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to All Programs, click Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.</li> <li>Expand SQL Native Client Configuration, right-click Aliases, and then click New Alias.</li> <li>In the Alias-New dialog box enter the following information, and then click OK: <ul> <li>Alias Name: Type the alias name that you want to use.</li> <li>Port Number: Type the port number that you want to use.</li> <li>Protocol: Select TCP/IP.</li> <li>Server: Type the name of the server where the alias will point.</li></ul> </li> <li>Restart IIS. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.</li></ol> </li></ol>

Additional query words: MOSS2007 SPS

Keywords: kbhowto kbconfig kbinfo KB889647

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.