Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
albracco
Starting Member
1 Post |
 Posted - 2007-09-21 : 21:41:33
|
| 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: 17If 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! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-22 : 22:12:12
|
| Traces network traffic? Checked dns servers? |
 |
|
|
|
|
|
SQL ERROR 53, SQL ERROR 17