You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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

Step 3: Enabling TCP/IP on Microsoft SQL Server 2012


Figure 1: Sql Server Configuration Manager

  1. 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 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 -ao.


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".
  • No labels