Search This Blog

Thursday 15 November 2012

SQL Server Firewall Rule


Run this command to create firewall rule.

-- For SQL Server
netsh advfirewall firewall add rule name="SQL Server 1433" dir=in action=allow protocol=TCP localport=1433

--For Mirroring


netsh advfirewall firewall add rule name="SQL Server Mirroring" dir=in action=allow protocol=TCP localport=5022