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

步骤 3: 启用Microsoft SQL Server 2012 TCP/IP

Figure 1: Sql Server Configuration Manager

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

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

1. 右键点击 TCP/IP 选择 属性.
2. 选择 IP2, 设置您的本地 IP 地址 IP Address.
3. 移除 TCP Dynamic Ports 值.

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

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

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

1. 重启服务.

Figure 5: Verify the listening port using command prompt

1. 执行 netstat -ao 命令检查监听是否已工作.

Figure 6: Verify instance based on the PID

1. 执行 tasklist /fi "pid eq 4488" 命令检查监听线程ID.