How to Create Inbound Firewall Rule for SQL Server Ports in Servidor Windows 2012 R2. Let’s create a rule for SQL Server ports (which I’m going to use in SCCM despliegue).
1. Start the system and registro en (with admin rights user);
2. Abierto Panel de control (you may use the search or Right Mouse Button to click on Comenzar). Hacer clic en Cortafuegos de Windows;
3. After that click on Advanced Settings;
4. Cortafuegos de Windows console open. If you click on Propiedades (right side) – you can disable firewalls for all networks. We going to Inbound Rules (left side) for our rule creation;
5. Hacer clic en New Rule;
6. Rule creation process begins. en mi caso, I create a rule for Inbound TCP ports. Para Rule Type select option Port y haga clic Próximo;
7. Para Protocol and Ports select option TCP y Special Local Ports. yo uso 2 ports for SCCM despliegue (8080, 14331) and also added standard SQL TCP ports. After entering ports click Próximo;
8. Para Action (in this case leave by default Allow the connection). Hacer clic Próximo;
9. Para Profile select all network profiles, hacer clic Próximo;
10. Enter the name of your rule (Por ejemplo SQL TCP), so you can easily find it in the future. Hacer clic Finalizar;
11. In the last screenshot, you see two rules, which I created for SQL Servidor. One for TCP ports and one for UPD puerto (1434).
