Article ID: 823938 - View products that this article applies to.
Expand all | Collapse all

Summary

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.

More information

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

Troubleshooting

References

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
286303 Behavior of SQL Server 2000 network library during dynamic port detection
273673 Description of SQL Virtual Server client connections
328383 SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server
For 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://blogs.msdn.com/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to-listen-on-different-ports-on-different-ip-addresses.aspx

Properties

Article ID: 823938 - Last Review: July 12, 2013 - Revision: 11.1
Applies to
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
kbsqlsetup kbsql2005cluster kbconnectivity kbupdate kbsqlclient kbnetwork kbfirewall kbconfig kbregistry kbhowtomaster KB823938

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com