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