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

Editor to share with you an example of turning on SqlServer remote access, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

2 configure SQL Server Management Studio

The detailed configuration is as follows:

= > Open SQL Server Management Studio locally

= > Select "SQL Server", right-click = > attribute

Security = "SQL Server and Windows authentication modes = > failed logins only

Connection = > check "allow remote connection to this server" = > OK

Security = > sa = > attribute

General = > enter password = > check "enforce password Policy"

Status = > Grant = > enabled = > OK

The self-contained chief administrator is used here, which is generally for security reasons. We need to assign an account to each database to manage the database.

Select "SQL Server" = > restart

Select "Yes"

Restarting

3 configure Sqlserver configuration Manager

SQL Server configuration Manager

Sql Server Network configuration = > Protocol of MSSQLSERVER = > set TCP/IP to enabled

Sql Server network configuration = > protocols for MSSQLSERVER = > double-click "TCP/IP" = "IP address =" set IP and TCP ports

SQL Server service = > SQL Server = > restart

4 configure firewall

Control Panel = > system and Security = > Windows Firewall = "Advanced Settings

Inbound rule = > New rule

Port = > next step

TCP= > enter 1433 for a specific local port = > next

Check "allow connection" = > next step

When you can also use this rule to check all = > next step

Enter name = > finish

Finally, click "finish".

The above is all the contents of the article "an example of enabling SqlServer remote access". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.