Local database (SQL Server) Remote connection server-side server

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


Https://jingyan.baidu.com/article/6c67b1d6ca06f02787bb1ed1.html (

SQL Server R2 How to open a remote connection to a database

The local database (SQL Server 2012) connects to the extranet server's database, and the server side of the extranet needs to be configured as follows:

1. First, the Configuration management tool to open the data

2. Configure the associated client protocol to turn on TCP/IP

3. The default remote port of the database is 1433, but is not secure, you can manually change the port, the IP of the client protocol

Here we need to find the bottom of the IPAll, then modify the port, after the modification, Restart the database service----------------------------------------------------------------------------

4. After the configuration is done, then log in to the database locally, then right-click on the properties in the database service and select "link", tick allow remote

5. After this, continue to right-click on the database service, select "Register", register a database service

You can test it, save it, test it successfully, and prove that you can use the account to log in remotely-------------------------

6. After completing the above steps, you need to modify the firewall settings, of course, if the server is directly shut down, you do not need to configure, but generally speaking, security, the server still do not shut down the firewall.

(1). The first is to add a port to the firewall (here is the server port number you set, default 1433)

Open Control Panel--Windows firewall--Advanced settings--right-click on the stack, new rule--Select port----Set specific local port number--Allow link--tick all items-- Set name--Finish


(2). After the first step, the firewall continues to create a new stack rule, this time choose Add Program, add D:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\binn\ Sqlservr.exe

The sqlservr.exe here is in the folder where you installed the database.

Add the steps as above

Then, through the above configuration, we can again local access to the external network database, just enter the corresponding IP address and port number, login name, password on the line

It is important to note that the database server format: IP address, port number

The ', ' separated by the IP address and port number used

Local database (SQL Server) Remote connection server-side server

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.