Powershell SQL – Eingehende Regeln erstellen

Allgemein

SQL Server inbound rules

Damit ein SQL Server kommunizieren kann muss schon mal folgende Freischaltungen gesetzt werden:

powershell-sql-server-freigabe

netsh advfirewall firewall add rule name=”SQL Server Prog” dir=in action=allow program=”C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe” enable=yes profile=domain

netsh advfirewall firewall add rule name = “SQLPort TCP” dir = in protocol = tcp action = allow localport = 1433-1434 remoteip = localsubnet profile = DOMAIN

netsh advfirewall firewall add rule name = “SQLPort UDP” dir = in protocol = udp action = allow localport = 1433-1434 remoteip = localsubnet profile = DOMAIN

sql-server-firewall-regeln