Problems and fixes that are encountered by remote connection to SQL Server 2014

In the database engine can log on to the database through the IP address, remote login with other computers on the same network segment has been unsuccessful. View the information on the Internet as a host firewall problem.

Find the answers to the relevant documents on the Microsoft website. Http://msdn.microsoft.com/zh-cn/library/ms175043.aspx, as shown in the

Open the port for Windows firewall for TCP access

2. On the Start menu, click Run, type Wf.msc, and then click OK.

4. In Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then, in the action pane, click New Rule.

6. In the Rule Type dialog box, select port, and then click Next.

8. In the Protocols and Ports dialog box, select TCP. Select Specific local port, and then type the port number of the instance of the database engine, such as the port number 1433 for the default instance . Click Next.

10. In the Action dialog box, select allow connections, and then click Next.

12. In the Profile dialog box, select any configuration file that describes the computer's connection environment when you want to connect to the database engine, and then click Next.

14. In the Name dialog box, enter a name and description for this rule, and then click Finish.

Open access to SQL Server when using dynamic ports

2. On the Start menu, click Run, type Wf.msc, and then click OK.

4. In Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then, in the action pane, click New Rule.

6. In the Rule Type dialog box, select programs, and then click Next.

8. In the Programs dialog box, select this program path. Click Browse, navigate to the instance of SQL Server that you want to access through the firewall, and then click Open. by default, SQL Server is located in C:\Program Files\Microsoft SQL Server\mssql12. Mssqlserver\mssql\binn\sqlservr.exe. Click Next.

10. In the Action dialog box, select allow connections, and then click Next.

12. In the Profile dialog box, select any configuration file that describes the computer's connection environment when you want to connect to the database engine, and then click Next.

14. In the Name dialog box, enter a name and description for this rule, and then click Finish.

Logon through remote IP was successful.

Problems and fixes that are encountered by remote connection to SQL Server 2014