SQL Server Ports in der Firewall aktivieren

netsh advfirewall firewall add rule name=”Open Port 80″ dir=in action=allow protocol=TCP localPort=80

@echo =========  SQL Server Ports  ===================
@echo Aktiviere SQLServer Default Instance Port 1433
netsh advfirewall firewall add rule name=”SQL Server” dir=in action=allow protocol=TCP localPort=1433
@echo Aktiviere Dedicated Admin Connection Port 1434
netsh advfirewall firewall add rule name=”SQL Admin Connection” dir=in action=allow protocol=TCP localPort=1434
@echo Aktiviere Conventional SQL Server Service Broker Port 4022
netsh advfirewall firewall add rule name=”SQL Service Broker” dir=in action=allow protocol=TCP localPort=4022
@echo Aktiviere Transact SQL/RPC Port 135
netsh advfirewall firewall add rule name=”SQL Debugger/RPC” dir=in action=allow protocol=TCP localPort=135

@echo =========  Analysis Services Ports  ==============
@echo Aktiviere SSAS Default Instance Port 2383
netsh advfirewall firewall add rule name=”Analysis Services” dir=in action=allow protocol=TCP localPort=2383
@echo Aktiviere SQL Server Browser Service Port 2382
netsh advfirewall firewall add rule name=”SQL Browser” dir=in action=allow protocol=TCP localPort=2382

@echo =========  Diverse Ports  ==============
@echo Aktiviere HTTP Port 80
netsh advfirewall firewall add rule name=”HTTP” dir=in action=allow protocol=TCP localPort=80
@echo Aktiviere SSL Port 443
netsh advfirewall firewall add rule name=”SSL” dir=in action=allow protocol=TCP localPort=443
@echo Aktiviere Port fuer SQL Server Browser Service’s ‘Browse’ Button
netsh advfirewall firewall add rule name=”SQL Browser” dir=in action=allow protocol=UDP localPort=1434
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE