Abrir puertos del Firewall para SQL Server

Script para habilitar los puertos del Firewall, lo mas practico es copiar y guardar estas instrucciones como un archivo de extensión cmd para luego poder ejecutarlo con un doble click:

 

@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

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Este sitio usa Akismet para reducir el spam. Aprende cómo se procesan los datos de tus comentarios.