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

Source: Internet
Author: User
Tags microsoft sql server microsoft website

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
  1. On the Start menu, click Run, type Wf.msc, and then click OK.

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

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

  4. 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.

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

  6. 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.

  7. 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
  1. On the Start menu, click Run, type Wf.msc, and then click OK.

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

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

  4. 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.

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

  6. 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.

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.