SQL Management Studio 的 Windows 防火墙规则 [英] Windows Firewall Rules For SQL Management Studio

问题描述

这篇文章的目的是找出为什么我无法从 Windows 10 系统登录到远程 SQL Server 实例.我的 Windows 10 系统连接正常，并且防火墙规则太多且不受限制.

The purpose of this post is to find out why I cannot log into a remote SQL Server instance from a Windows 10 system. My Windows 10 system connects just fine, and has fire wall rules that are too many and to un-restrictive.

因此，我想收紧我的 Windows 10/Windows Defender 入站和出站防火墙规则，我相信这些规则允许 SQL Server Management Studio 与远程节点上的 SQL Server 通信.客户端和服务器都在同一个域中.

Therefore, I would like to tighten my Windows 10/Windows Defender inbound and outbound firewall rules that I believe allow SQL Server Management Studio to talk to a SQL Server on a remote node. Both the client and server are on the same domain.

远程服务器上的 SQL 实例使用动态端口 49365.

The SQL instance on the remote server uses dynamic port 49365.

我有一个入站规则，本地和远程端口不受限制的 TCP.这条规则应该缩小到哪些端口?

I have as an inbound rule, unrestricted TCP for local and remote ports. To which ports should this rule be narrowed?

对于我的出站规则，我有一个适用于所有本地端口和远程端口 1434 的 UDP 协议.

For my outbound rule, I have a UDP protocol for all local ports and remote port 1434.

我相信这个疯狂的配置允许 SQL Management Studio 与动态端口 49365 上的远程 SQL 服务器通信.

I believe this crazy configuration allows SQL Management Studio to talk to a remote SQL server on dynamic port 49365.

问题 1:我的防火墙规则设置到底应该是什么?

Questions 1: What should my firewall rule settings really be?

(我将作为单独的 OP 来问问题 2.)

(I'm going to ask Question 2 as a separate OP.)

推荐答案

我认为您必须在 SQL Server 中创建一个允许端口 1433/1433 的入站规则.动态端口对于此配置并不重要.

i think you have to create an inbound rule in the SQL Server permiting port 1433/ 1433 . The dynamic port its not important for this configuration.

这篇关于SQL Management Studio 的 Windows 防火墙规则的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！