Page History

以下指引承接 Configure for 配置 MS SQL Server 2005 步骤2. 然后,我们需要启用一个监听端口用于连接.

...

步骤 3:

...

启用Microsoft SQL Server 2012 TCP/IP

...

Figure 1: Sql Server Configuration Manager

1. Enable 启用Enable named pipes and TCP/IP.
2. Open up 打开 TCP/IP Properties属性.

Figure 2: IP2 - TCP/IP Properties Under Protocols for SQLEXPRESS

1. Right-click on 右键点击 TCP/IP and select Properties选择 属性.
2. Go to 选择 IP2, set your local IP Address in 设置您的本地 IP 地址 IP Address.
3. Remove 移除 TCP Dynamic Ports value 值.

Figure 3: IPALL - TCP/IP Properties Under Protocols for SQLEXPRESS

1. Go to 选择 IPAll.
2. Empty 清空 TCP Dynamic Ports value 值.
3. Set 设置 TCP Port value to  端口为 1433.

Figure 4: Restart SQL Server Service for changes to take effect

1. Restart the server for the changes to take effect重启服务.

Figure 5: Verify the listening port using command prompt

1. Verify that the listener is working through command prompt by executing 执行 netstat -aoao 命令检查监听是否已工作.

Figure 6: Verify instance based on the PID

1. Check on which process instance is listening to the port by executing 执行 tasklist /fi "pid eq 4488" 命令检查监听线程ID.