How to Create Inbound Firewall Rule for SQL Server Ports in Windows服务器 2012 R2. Let’s create a rule for SQL Server ports (which I’m going to use in SCCM 部署).
1. Start the system and 日志 在 (with admin rights user);
2. 打开 控制面板 (you may use the search or Right Mouse Button to click on 开始). 点击 Windows 防火墙;
3. After that click on Advanced Settings;
4. Windows 防火墙 console open. If you click on 特性 (right side) – you can disable firewalls for all networks. We going to Inbound Rules (left side) for our rule creation;
5. 点击 New Rule;
6. Rule creation process begins. 就我而言, I create a rule for Inbound TCP ports. 为了 Rule Type select option Port 然后单击 下一个;
7. 为了 Protocol and Ports select option TCP 和 Special Local Ports. 我用 2 ports for SCCM 部署 (8080, 14331) and also added standard SQL TCP ports. After entering ports click 下一个;
8. 为了 Action (in this case leave by default Allow the connection). 点击 下一个;
9. 为了 Profile select all network profiles, 点击 下一个;
10. Enter the name of your rule (例如 SQL TCP), so you can easily find it in the future. 点击 结束;
11. In the last screenshot, you see two rules, which I created for SQL 服务器. One for TCP ports and one for UPD port (1434).
