这篇文章的目的是找出为什么我无法从 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 防火墙规则
发布评论