Re: SQL Server goes down when internet is disconnected

From: Jeff Clausius (jeffc_at_raegecruos.com)
Date: 11/04/03 

Date: Tue, 04 Nov 2003 07:03:45 -0800

daniel:

this may or may not be related, but i wanted to share this story anyway.

i use a ibm thinkpad for development. sometimes, when at a client's
site, i will be connected to the internet via dial-up modem.

here is the strange behavior:

- database is local on win xp - sql server developer edition
- connected to the internet, just to reference web resource or e-mail
- running a large, large query (or rebuilding index or other dbcc
command on the local db)
- disconnect the modem, when done with mail, etc.
- the query in step 3 stops, w/ a network error message.

this is only a guess, but i can only figure when there is a change in
network configuration, the o/s must decide to re-do the tcp/ip network
stack. at this point, i believe the win xp sends something in the
network api to sql server that the network had an outage and sql server
stops the query, or perhaps the stack totally disappears, and sql server
stops the query. again just a guess.

can anyone add to this discussion?

jeff clausius
sourcegear corporation

"Daniel Jorge" <danielj@afc.com.br> wrote in
news:udU23rhoDHA.2232@TK2MSFTNGP09.phx.gbl:

> Hi there,
>
> I'm having a small problem with my SQL Server when the Internet
> goes
> down in my network
>
> The structure we have is something like this:
>
> INTERNET ----> Linux Server --> Switch
> Connected to this Switch we have our PDC (Wind2k Server Small
> Business)
> with our client machines (varying from windows 98 to windows XP Pro)
>
> Every time the internet goes down, or we have to reboot the Linux
> server, the SQL Server Stops.. well, it doesn't exactly stops... all
> applications that uses it return a Timeout message, but the service is
> still UP.
> Would that be a configuration in the Client Machines; in the Win2k
> Srv
> or in SQL Server itslef?
>
> Any help or direction will be very useful
>
> Thank you very much
>
>
> Daniel
>
>
>

Relevant Pages

  • Odd connection problem (proxy + internal)
    ... system and can not be placed facing the internet. ... that belongs to our network and also connects to this accounting ... DSN's) to our internal SQL server. ... by installing the Winsock proxy on the SQL server and mapping the ip ...
    (comp.databases.ms-sqlserver)
  • Re: Cant use OPENROWSET with NT Authenticated User
    ... SQL Server Link to Remote Database Fails with Error ... If I run the query from the SQL Server machine it ... >>make 2 hops on the network to access the database file. ... >>1st hop to SQL Server, and 2nd hop back to the client to ...
    (microsoft.public.sqlserver.security)
  • Re: .NET new executable
    ... You need to decide the application type based on availabe infrastructure - networked privately, or the Internet only, or not networked at all... ... You could also use Windows app with ClickOnce (you then still need a web server to distribute the ClickOnce app, if the user is not on a LAN, and how about database access: where the database is and how the windows app access the data via the Internet?). ... In an extreme case where no network access avaialble, you could send your app to your user via email, then user runs it on his computer, save data to a file, email back to you; then you update the data into database. ... If all you are trying to do is send some data to your SQL server, ...
    (microsoft.public.dotnet.general)
  • Re: query analyzer -> slow file menu
    ... SQL Server MVP ... > (File, Edit, Query, Tools, Window and Help) just fine. ... > However, if I try to acess the "File" menu, my whole machine locks for ... the network ...
    (microsoft.public.sqlserver.server)
  • Re: Date Formats: VB/ADO to SQL Server 2k
    ... How do you pass this date to the SQL Server? ... this case is to pass them as a parameters in your query. ... > It appears that on our network, the error date format of '2004-04-21 ... If I change the date format to '20040421 14:10:30' it ...
    (microsoft.public.vb.database.ado)