Article ID: 823938 - View products that this article applies to.
This article describes static and dynamic port allocation in Microsoft SQL Server 2008, SQL Server 2005, or SQL Server 2000 . It also discusses how to configure an instance of SQL Server to use either a static port or a dynamic port.
Static port allocation
Dynamic port allocation
Verifying the port configuration of an instance of SQL Server
Configuring an instance of SQL Server to use a static port
Configuring an instance of SQL Server to use a dynamic port
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/286303/ )Behavior of SQL Server 2000 network library during dynamic port detection
(http://support.microsoft.com/kb/273673/ )Description of SQL Virtual Server client connections
328383For more information about how to configure SQL Server to listen on different ports on different IP addresses, see the How to configure SQL server to listen on different ports on different IP addresses? topic on the following Microsoft SQL Server Support Blog website:
(http://support.microsoft.com/kb/328383/ )SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server
Article ID: 823938 - Last Review: July 12, 2013 - Revision: 11.1
Contact us for more help
Connect with Answer Desk for expert help.