ODBC SQL connection not working over PPTP VPN
Posted on 2013-02-01
We had a workstation connecting to a SQL server over a normal LAN. Everything worked. We had to move this workstation to a new office but wanted to still have access to this software. We disjoined the workstation from the domain, moved it, and connected it to the VPN. This is the error we get when opening the software. "Invalid user authorization specification: invalid user ID or password" We've reinstalled the software, and are 100% sure that the user ID and password is correct in the ODBC settings. We had the software company login and they spent hours working on this but insist it's a networking issue, which I agree since it worked fine before the move. I've also disabled all firewalls on both ends including the firewall on the network adapters. client pc is XP connecting to server 2003 standard. Also, I am using the domain admin account for testing to connect.