MS SQL Settings Remote connection

Http://blog.sina.com.cn/s/blog_62cac8510102uxsl.html

How to turn on remote access for SQL Server 2014: Note: (emphasis)

1. When you access the server with a computer name, you need to turn on the SQL Server Browser service.

2. check the settings of your own firewall and your own firewall to release the appropriate ports and programs. The SQL Service port is: 1433

3. You can check whether port 1433 is turned on by Netstat-an command. All listening is as follows:

4. If you have enabled the use SQL Server and Windows authentication hybrid login When you install SQL Server, you can skip the second item in the configuration procedure below.

configuration process:

1. SQL Server Configuration Manager (abbreviated SSCM)

Check the SQL Server service on the left to make sure that the status of SQL Server (instance name) and SQL Server Browser on the right is running.

Note that if the SQL Server and SQL Server Browser states are stopped, you need to:

Control Panel > System and Security > Administrative Tools > Services, right-click SQL Server Browser > Proper Ties > General tab, change Startup type to Automatic, click Apply button, then click the Start button in Service Status is A.

Select the protocol for the instance name in SQL Server network configuration on the left to make sure that TCP/IP, Named Pipes is enabled on the right.

Double-click TCP/IP, open the Properties page, and set enabled to Yes. Note the "Listen All" item, which is mentioned later in this article.

If you previously "listen All" to "yes", the "IPALL" setting. If you have previously listened to no, you need to turn on the IP you want to listen on separately: TCP dynamic port is set to NULL, TCP port is set to 1433, enabled is set to Yes.

Select "Client protocols" on the left, enable "TCP/IP" and "Named Pipes" on the right

Set the properties of "TCP/IP" in it.

Back in the first step, restart the SQL Server service.

2. SQL Server Management Studio (SSMS)

Open SSMs, connect to the database as Windows, log on, right-select Properties

On the left, select "Security" and select "SQL Server and Windows authentication mode" on the right to enable hybrid login mode

Select "Connect", check "Allow remote connection to this server", then click "OK"

Expand Security, login name, SA, right-select Properties

On the left, select General, select SQL Server authentication on the right, and set the password

Select "Status", select "Enable", click "OK"

Right-click on the database Select "Facet"

Set the "Remoteaccessenabled" property to "True" and point to "OK"

This has been set up. After exiting with the account SA login, success means that the SA account is enabled. After Setup is complete. It's best to restart your computer and then you can manage and manipulate the database remotely.

MS SQL Settings Remote connection