Script para Abrir Puertos del Firewall para SQL

Este script puede copiarse y guardarse como un archivo de extensión ".CMD"

@echo off @echo This scripts sets the default firewall configurations for SQL Server components echo. echo Setting the core components for a database instance   echo Default Instance netsh advfirewall firewall add rule name="SQLServer" dir=in action=allow protocol=TCP localport=1433 profile=DOMAIN   echo Dedicated Admin Connection netsh advfirewall firewall add rule name="SQL DAC" dir=in action=allow protocol=TCP localport=1434 profile=DOMAIN     echo SQL Browser Service netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow protocol=UDP localport=1434 profile=DOMAIN       echo Setting the core firewall rules for database mirroring, service broker, TSQL Debugger, Analysis services, Reporting Services   echo Mirroring EndPoint - CHANGE PORT NUMBER AS NEEDED depending on which role netsh advfirewall firewall add rule name="Mirroring EndPoint" dir=in action=allow protocol=TCP localport=5022 profile=DOMAIN     echo Service Broker netsh advfirewall firewall add rule name="SQL Service Broker" dir=in action=allow protocol=TCP localport=4022 profile=DOMAIN     echo Enable TSQL Debugger (uses RPC) netsh advfirewall firewall add rule name="T-SQL Debugger" dir=in action=allow protocol=TCP localport=135 profile=DOMAIN   echo Browser service for Analysis Services netsh advfirewall firewall add rule name="SQL Browser for Analysis Services" dir=in action=allow protocol=TCP localport=2382 profile=DOMAIN     echo Analysis services Default Instance netsh advfirewall firewall add rule name="Analysis Services" dir=in action=allow protocol=TCP localport=2383 profile=DOMAIN     echo HTTP/HTTPS for reporting services netsh advfirewall firewall add rule name="HTTP Reporting Services" dir=in action=allow protocol=TCP localport=80 profile=DOMAIN netsh advfirewall firewall add rule name="HTTPS Reporting Services" dir=in action=allow protocol=TCP localport=443 profile=DOMAIN