Configure SQL Server to allow remote connections

Source: Internet
Author: User
Tags microsoft sql server mssqlserver

Need someone to remote your database, the first need is in a LAN, or connected to the same router, followed by the specific steps:

(i) The first step is to check whether remote links are allowed in the SQL Server database servers. The specific actions are:

(1) Open the database, log in with a local account, right-click the first option and select Properties:

(2) In the Properties window that opens, click "Connect" on its right and then "Allow remote connection to this server" on the left side:

(ii) Configure the appropriate protocol for Microsoft SQL Server (MSSQLServer).

(1) Select: Start-〉 All Programs-〉microsoft SQL Server 2008-〉 Configuration tool-〉sql Server Configuration Manager, as shown in:

(2) After opening SQL Server Configuration Manager, select MSSQLSERVER under SQL Server network configuration and see if TCP/IP is "enabled" on the right, as shown in:

(iii) Check SQL Server firewall settings (Quick steps-Direct firewall off (unsafe))

(1) After the last two steps, the user needs to do is to reconfigure the SQL Server firewall. When you do this, first locate the port on the SQL Server that supports the TCP/IP protocol. Users can right-click the TCP/IP protocol to select Properties when the SQL Server firewall is already running:

As we can see, the TCP/IP protocol supported on this SQL Server is port 1433. The next step is to allow 1433 ports to support the TCP/IP protocol in the configuration of the firewall. If the server is running a Windows 7 operating system, its configuration steps are (similar to other Microsoft operating systems), open Control Panel, select the Windows Firewall option, and then click Advanced Options, as shown in:

(2) After selecting "Advanced Settings", in the right menu bar, find "Windows Firewall with Advanced Security options" and open it. When you open it, you will find the "inbound rules" option in the left menu bar. Inboud Open the option and select the new Rule option in the right-hand menu bar:

(3) After opening the new Rule option, configure the internal binding protocol for the 1433 port with the new built-in binding Rule Wizard to apply to the TCP/IP protocol. (provided that you need to complete all the steps previously described in this step), the 1433 port configuration for port 1433 is available according to the following diagram:

Finally click "Finish". Test method: Find a computer in the LAN, open SQL Server database, and then enter your IP and password, if you can connect, it is configured, as shown in:

Configure SQL Server to allow remote connections

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