Pages

Tuesday, January 7, 2014

Compiled Thoughts: Understanding MS SQL Server Named Instance Connections

The following blog post by Peter Lanoie helped me to better understand how SQL Server instances use ports:
Compiled Thoughts: Understanding MS SQL Server Named Instance Connections

Take note that the default instance of SQL Server listens on TCP port 1433, while the SQL Browser listens on UDP port 1434.  If you open port 1434 in your firewall for the TCP\IP protocol the SQL Browser will still appear not to be working and you will still have to provide the port number when connecting to a named instance.

Just for interest sake: TCP vs UDP