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 Express listen on dynamic ports.
1.In
SQL Server Configuration Manager , expand
SQL Server Network Configuration , and then click on the server instance you want to configure.
2.In the right pane, double-click
TCP/IP .
3. In the TCP/IP
Properties dialog box, click the
IP Addresses tab.
4.In the TCP Port box of the
IPAll section, type an available port number. For this tutorial, we will use
XXXXX.
5.Click OK to close the dialog box, and click OK to the warning that the service must be restarted.
6.In the left pane, click SQL Server Services.
7.In the right pane, right-click the instance of SQL Server, and then click
Restart . When the Database Engine restarts, it will listen on port
XXXXX