dbTalk Databases Forums  

Problem connecting to SQL Server over firewall

microsoft.public.sqlserver.connect microsoft.public.sqlserver.connect


Discuss Problem connecting to SQL Server over firewall in the microsoft.public.sqlserver.connect forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Igor Marchenko
 
Posts: n/a

Default Problem connecting to SQL Server over firewall - 08-13-2010 , 01:29 PM






Hello!

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
firewall restrictions.
Any help is greatly appreciated.

Igor

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.