Microsoft SQL connection error with firewall turned on
Posted on 2009-04-28
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;
SQL Server Error: 53
[Micosoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen (Connect()).
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.