Configuring SQL Server Ports with netsh in Windows

Published by david on

Command line :

netsh advfirewall firewall add rule name="SQL Server" dir=in action=allow localport=1433 protocol=TCP
netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow localport=1434 protocol=UDP
netsh advfirewall firewall add rule name="SQL Admin Connection" dir=in action=allow localport=1434 protocol=TCP
netsh advfirewall firewall add rule name="SQL Service Broker" dir=in action=allow localport=4022 protocol=TCP
netsh advfirewall firewall add rule name="SQL Mirror Port" dir=in action=allow localport=5022 protocol=TCP
Categories: SQL
Tags:

0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

SQL

SQL and MDT: Firewall Configuration

Configure your firewall for SQL and MDT integration

SQL

Database Optimization: Purging SQL Logs (LDF)

Learn how to optimize your SQL database by purging logs (LDF). Reduce your log file size and enhance your database performance.

SQL

How to Modify Over 200 Rows in SQL Management Studio

Learn the step-by-step process to efficiently modify more than 200 rows in SQL Management Studio. Discover how to adjust settings in the SQL Server Object Explorer to increase the default row limit