How to Create Inbound Firewall Rule for SQL Server Ports in Windows Server 2012 आर2. Let’s create a rule for SQL Server ports (which I’m going to use in SCCM deployment).
1. Start the system and log in (with admin rights user);
2. खुला Control Panel (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 गुण (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 deployment (8080, 14331) and also added standard SQL TCP ports. After entering ports click अगला;
8. के लिए कार्रवाई (in this case leave by default Allow the connection). क्लिक अगला;
9. के लिए Profile select all network profiles, क्लिक अगला;
10. Enter the name of your rule (for example 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 Server. One for TCP ports and one for UPD port (1434).