netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN 有关使用 netsh 配置 SQL Server 的脚本,请参阅如何在运行 Windows XP Service Pack 2 的系统上使用脚本以编程方式打开端口供 SQL Server 使用。有...
您可以使用適用於進階安全性的 Windows 防火牆協助程式,稱為 advfirewall。 本文所述的許多設定選項都可以使用 netsh advfirewall 從命令列設定。 例如,在命令提示字元中執行下列指令碼,即可開啟主控台 複製 netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow local...
請參閱下列為 SQL Server 預設執行個體及 SQL Server Browser 服務開啟 TCP 連接埠 1433 和 UDP 連接埠 1434 的範例: PowerShell複製 New-NetFirewallRule-DisplayName"SQLServer default instance"-DirectionInbound-LocalPort1433-ProtocolTCP-ActionAllowNew-NetFirewallRule-DisplayName"SQLServer Browser s...
请参阅下面的示例,打开 SQL Server 默认实例和 SQL Server Browser 服务的 TCP 端口 1433 和 UDP 端口 1434: PowerShell复制 New-NetFirewallRule-DisplayName"SQLServer default instance"-DirectionInbound-LocalPort1433-ProtocolTCP-ActionAllowNew-NetFirewallRule-DisplayName"SQLServer Browser service"...
请参阅下面的示例,打开 SQL Server 默认实例和 SQL Server Browser 服务的 TCP 端口 1433 和 UDP 端口 1434: PowerShell复制 New-NetFirewallRule-DisplayName"SQLServer default instance"-DirectionInbound-LocalPort1433-ProtocolTCP-ActionAllowNew-NetFirewallRule-DisplayName"SQLServer Browser service"-DirectionIn...
请参阅下面的示例,打开 SQL Server 默认实例和 SQL Server Browser 服务的 TCP 端口 1433 和 UDP 端口 1434: PowerShell复制 New-NetFirewallRule-DisplayName"SQLServer default instance"-DirectionInbound-LocalPort1433-ProtocolTCP-ActionAllowNew-NetFirewallRule-DisplayName"SQLServer Browser service"-DirectionIn...
If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server. The firewall is a component of Microso...
netsh advfirewall firewall add rulename=SQLPortdir=inprotocol=tcpaction=allowlocalport=1433remoteip=localsubnetprofile=DOMAIN 1. 有关使用 netsh 配置 SQL Server 的脚本,请参阅如何在运行 Windows XP Service Pack 2 的系统上使用脚本以编程方式打开端口供 SQL Server 使用。有关 netsh 的详细信息,请参阅...
Windows Firewall with Advanced Security Design Guide(高级安全 Windows 防火墙设计指南) Introduction to Server and Domain Isolation(服务器和域隔离简介) 默认防火墙设置 规划防火墙配置的第一步是确定操作系统的防火墙的当前状态。如果操作系统是从早期版本升级而来,则可能已保留以前的防火墙设置。此外,防火墙设置可能已...
If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server. The firewall is a component of Micr...