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

This article mainly explains "how to add SQL Server firewall rules", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "how to add SQL Server firewall rules" bar!

In general, rules are automatically added to the firewall when you install SQL Server. If not added, it may cause remote access to be blocked and unable to connect to the database.

For the default instance, you only need to add the executable file on the server side in the inbound rule. For named instances, you need to add SQL Server Browser to the rule, which is similar to adding server-side rules.

The following is from the official Microsoft documentation:

Open access to SQL Server when using a dynamic port

1. On the start menu, click run, type WF.msc, and then click OK.

2. In the left pane of Advanced Security Windows Firewall, right-click inbound rules, and then click New Rule in the actions pane.

In the Rule Type dialog box, select programs, and then click next.

4. In the programs dialog box, select this program path. Click Browse, navigate to the SQL Server instance that you want to access through the firewall, and then click Open. By default, SQL Server is located at C:\ Program Files\ Microsoft SQL Server\ MSSQL13.MSSQLSERVER\ MSSQL\ Binn\ Sqlservr.exe. Click next.

In the actions dialog box, select allow connection, and then click next.

6. In the profile dialog box, select any profile that describes the computer's connection environment when you want to connect to the database engine, and then click next.

In the name dialog box, enter a name and description for this rule, and then click finish.

Thank you for your reading, the above is the content of "how to add SQL Server firewall rules", after the study of this article, I believe you have a deeper understanding of how to add SQL Server firewall rules, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.