Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to enable remote access in SqlServer

2025-01-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Today, I will talk to you about how to enable remote access in SqlServer. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something from this article.

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

After reading the above, do you have any further understanding of how to enable remote access in SqlServer? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.

Views: 293

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report