Knowledge - Details

Cannot connect to SQL Instance remotely
Date Added: 5/13/2014

The default SQL instance uses port 1433 by default.
The SQL Browser service uses port 1434.
Named instances use a dynamic port range by default.

Make sure you have Windows firewall rules created to allow each port.  The SQL instances use TCP and the Browser uses UDP.

Because the Named instances use dynamic ports, it's easiest if you change their settings to use a single static port, starting at 1435.  That way, your firewall rules can open only a single port.

After changing the IP settings using the Config Manager, remember to restart the SQL services to apply the changes.

Back to List

Disclaimer: Everything on this website is written for my own use. I disclaim any guarantees that the procedures and advice listed here are accurate, safe, or beneficial for anyone else. If you attempt to follow any procedures or advice shared here, you do it at your own risk. Part of IT work is knowing how to recover from problems.