SQL server 2000 with remote clients at 3 locations. Sites had been connected via leased line. We switched everything to internet/VPN. Everything works, but a several times a day, the clients receive this error:
Microsoft SQL Server LoginConnection failed:SQL State: '01000'SQL Server Error: 53[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection open(connect ( ) )Connection failed:SQL State: '08001'SQL Server Error: 17
If they exit and log back in, then it's OK. Here's what has changed:
New ISP at HQ and remote sites with new static IPs. New firewalls/VPN setup. VPNs setup to alloow all traffic between sites. Internal IP addresses/computer names did not change. Only exception is the HQ gateway is different, but all network settings were updated to reflect that. I have all of the remote firewalls pinging the HQ firewall every 30 seconds and have not seen any hint of a problem in the firewall logs. Seems to be isolated to SQL. None of the SQL server or client configs were touched. I know little about SQL. What do the errors above mean and does anyone have any ideas? THANKS!
View Complete Post