Problem connecting to SQL Server over firewall - 08-13-2010 , 01:29 PM
I am troubleshooting connectivity from client computer to SQL Server 2008
named instance. We have opened 1433 and 1434 ports to allow connectivity. I
am able to connect using <SQLServerName>\<InstanceName>,<PortNumber> syntax.
But I would like to connect without specifying port number. SQL Server
Browser service is running on SQL Server. Also, IPall settings in TCP/IP
protocol is configured to use dynamic port in question.
I am not sure if there any other ports that I have to open to allow
connection without specifying port nunber. I am able to connect using
<SQLServerName>\<InstanceName> from clients that don't go through firewall
(for exmaple, inside SQL Server network). That makes me think this is
Any help is greatly appreciated.