SQL SERVER ERROR 53 and SQL SERVER ERROR 17

• Al Bracco

  SSC Veteran

  Points: 265

  More actions

  September 21, 2007 at 8:24 pm

  #70214

  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 Login

  Connection 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!