修改 SQL Server的TCP/IP端口步驟
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 1500.
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 1500.
8.Use MicroSoft SQL
SERVER Management Studio to access db , by sql connect string 『xxx.xxx.xxx.xxx\SQLEXPRESS,1500』