Connection problems when internet is down

From: Tracey Hughes (tracey_at_traceyhughesconsulting.com)
Date: 06/27/04 

Date: Sun, 27 Jun 2004 10:13:07 -0700

I am running SQL Server 2000 on a Windows 2000 server with
10 clients connecting. Everything runs fine until the
internet goes down. When the internet goes down, the
clients have intermittent connection problems much like
those described in Microsoft Knowledge Base Article -
328476 about TCP/IP settings for drivers w/ pooling
disabled.
"...with a stress-related socket issue, the problem occurs
intermittently as the stress rises and falls. The computer
may run for hours with no errors, then the error occurs
one or two times, and the computer then runs for several
more hours with no errors. Also, when you have this
problem, general connectivity to SQL Server works one
instant, fails the next, then works again the next
instant."

I should note the connection problems are even at the
Enterprise Manager level. When the internet is down, I can
rarely get my instance to register in the E.M. The rest of
the network seems to be running fine w/ the internet down.
So what does SQL server have to do with the internet in
this instance? Please help! Driving me nuts.

Relevant Pages

  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Help!! Client side database access
    ... private void StartWatch() ... Inside class checking internet connection ... > exposing your sql server on the internet and opening port 1433 on your ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: connecting to SQL Server 2000 from a VB.net app using ADO.net
    ... In terms of connectivity issues over the Internet, firewall ... TCP Ports Needed for Communication to SQL Server ... I can't create a remote connection in Enterprise Manager. ...
    (microsoft.public.sqlserver.connect)
  • Re: Internet Explorer - Page not found
    ... It will help to know what your internet connection is, ... turn on modem first, router second, computer third etc... ... It will also help to know if you have a firewall such as Norton Internet ... If you have connection problems it can be handy to have a choice for ...
    (microsoft.public.windows.inetexplorer.ie6.setup)
  • Re: Performance of ODBC
    ... Usiing Access front-end to connection a back end through ... the Internet connection is definitely slow with currently affordable network ... Unless you can get a network connection that fast enough and ... that Access is the front end, and the SQL server is the back end. ...
    (microsoft.public.access.adp.sqlserver)
Loading