IT이야기/MS-SQL

MSSQL 방화벽 허용 파워쉘

주현ㅇHㅂI 2015. 6. 15. 13:09
728x90
 

New-NetFirewallRule -DisplayName "MSSQL BROWSER UDP" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow

New-NetFirewallRule -DisplayName "MSSQL ENGINE TCP" -Direction Inbound -LocalPort 1433-1434 -Protocol TCP -Action Allow

New-NetFirewallRule -DisplayName "MSSQL AOAG EP TCP" -Direction Inbound -LocalPort 5022 -Protocol TCP -Action Allow

netsh advfirewall firewall set rule group="File and Printer Sharing" new enable=yes

 

728x90