TOUGH ONE: ODBC connection over VPN tunnel on 2 seperate domains!
Posted on 2010-09-16
Hey guys - this is going to be a tough one i'm pretty sure :p
Here's the situation - we have two different sites - each with a different windows domain. We have a SQL server on domain 1. Then on domain 2, there is a computer that's not a member of either domain (it's just in a workgroup). There is a VPN tunnel connecting the two sites together. DNS doesn't work across the VPN tunnel, but i have edited the hosts file on the computer, and so i can ping the SQL server (across the VPN tunnel) by both hostname or by IP address.
I've tried setting up an ODBC connection to the SQL server using both IP address, hostname, the works. I get the error that the SQL server doesn't exist, or access denied. i've tried both TCP/IP, and Named Pipes, but neither work.
SQL server is running SQL 2005 standard, with all patches and updates.
CLIFF-NOTES VERSION: VPN tunnel between two sites, and 2 domains. One workstation (not on either domain) trying to connect to SQL server on domain across tunnel to set up ODBC. it can ping the server, RDP to it, but can't set up ODBC connection.