RomanekT
asked on
Microsoft SQL connection error with firewall turned on
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!
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!
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
*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