?
Solved

Microsoft SQL connection error with firewall turned on

Posted on 2009-04-28
3
Medium Priority
?
267 Views
Last Modified: 2012-05-06
While mobile users are connected at the office with the local firewall turned off through group policy, multiple line of business apps that connect to different SQL 2005 servers work .  Once they leave the local network and connect outside, the firewall (Vista SP1) automatically turns on.  After connecting through a SSL VPN, the line of business apps fail with the following error;

Connection Failed:
SQLState:'01000'
SQL Server Error: 53
[Micosoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen (Connect()).
Connection failed:
SQLState:'08001'
SQL Server Error:17
[Micosoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

Allowing TCP/UDP ports 1433 and 1434 on the client do nothing.  If I completely disable the firewall for public networks on the client all the apps work fine.  I  really would rather not do that though.

Any suggestions?

Thanks!

 
0
Comment
Question by:RomanekT
  • 2
3 Comments
 
LVL 6

Expert Comment

by:mvgeertruyen
ID: 24254637
I think you have to do both ways:

*ANY* -> 1433
1433 -> *ANY*
http://support.microsoft.com/kb/287932

What you could also do is enable firewall logging on the client (may need a restart to enable) to spot where traffic is being dropped.

Rgds
0
 

Author Comment

by:RomanekT
ID: 24254699
Thanks but that article doesn't apply to SQL 2005.  Also, all clients are Vista SP1.  There is no option in the firewall to make rules like ANY->1433, you can either pick an application or create an exception for a port.  
0
 
LVL 6

Accepted Solution

by:
mvgeertruyen earned 750 total points
ID: 24254790
You can using the advanced firewall feature in Vista (type advanced firewall in search). Ports should be the same...
(also be aware of the 3 profiles; public, domain and private)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question