Live Chat Software by Kayako |
Configure SQL Server to listen on a specific port
Posted by on 22 August 2012 11:08 AM
|
|
The default instance of the Database Engine listens on port 1433; therefore, you do not have to configure a fixed port. However, named instances including SQL Server 2005 Express Edition listen on dynamic ports. Before you can open a port in the firewall, you must first configure the Database Engine to listen on a specific port known as a fixed port or a static port; otherwise, the Database Engine might listen on a different port each time it is started.
Port number assignments are managed by the Internet Assigned Numbers Authority and are listed at http://www.iana.org/ Port numbers should be assigned from numbers 49152 through 65535. | |
|