以下指引承接 配置 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.
  • No labels