How to Create Inbound Firewall Rule for SQL Server Ports in 윈도우 서버 2012 R2. Let’s create a rule for SQL Server ports (which I’m going to use in SCCM deployment).
1. Start the system and 통나무 ~에 (with admin rights user);
2. 열려 있는 제어판 (you may use the search or Right Mouse Button to click on 시작). 클릭하세요 Windows Firewall;
3. After that click on Advanced Settings;
4. Windows Firewall console open. If you click on Properties (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. In my case, I create a rule for Inbound TCP ports. 을 위한 Rule Type select option Port 그리고 클릭 다음;
7. 을 위한 Protocol and Ports select option TCP 그리고 Special Local Ports. I use 2 ports for SCCM deployment (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. 딸깍 하는 소리 Finish;
11. In the last screenshot, you see two rules, which I created for SQL 섬기는 사람. One for TCP ports and one for UPD port (1434).
