Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to set up a remote connection in different versions of MSSQLSERVER. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

The scheme described in this paper is applicable to Microsoft Sql Server 2008 / 2012 / 2012 / 2012 / R2 / Universe 2014, hereinafter referred to as MSSQLSERVER.

MSSQL does not allow remote connections by default, and the sa account is disabled. If you want to use SSMS locally to connect to MSSQLSERVER on a remote server, you need to configure two parts:

1. SQL SERVER MANAGEMENT STUDIO (SSMS)

2. SQL SERVER configuration Manager (SQL SERVER CONFIGURATION MANAGER-SSCM)

It is also important to note that if some places do not take effect, restart sql server (you can find it from SSCM or system services). Here are the detailed steps:

STEP1. Open SSMS and use Windows identity to connect to the database. After logging in, right-click "Properties".

STEP 2. Select Security, select SQL SERVER and Windows authentication mode

STEP 3. Then select "Connect", check "allow remote connection to this server", and then click "OK" button.

STEP 4. Expand "Security"-"Login name -" sa, right-click "Properties"

STEP 5. In "regular", change your own password, which is your sa login password.

STEP 6. In status, enable sa login and click the OK button

STEP 7. Right-click the database server and select "aspect"

STEP 8. Select Server configuration, find RemoteAccessEnabled, and set it to "True"

STEP 9. Restart the SQL SERVER service, exit the current connection, and you should be able to log in using sa.

STEP 10. Configure SSCM, select "SQL SERVER Service" on the left, make sure "SQL SERVER" and "SQL SERVER BROWER" on the right are running, select "Network configuration", double-click TCP/IP, and make sure the status is "enabled"

STEP 11. Also make sure that TCP/IP is enabled in Client. The default port is 1433, which can be modified by yourself. The non-default port needs to be explicitly indicated in the connection string.

STEP 12. Restart the SQL SERVER service again here, and you should be ready to use it. But it doesn't work yet. Confirm the firewall port settings and add C:\ Program Files\ Microsoft SQL Server\ MSSQL10.SQLEXPRESS\ MSSQL\ Binn\ sqlservr.exe to the allowed list under the SQL SERVER installation directory.

This is the end of the article on "how to set up a remote connection in different versions of MSSQLSERVER". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.