Network Failure, SQL Failure

  • Thread starter Thread starter Mark Conway
  • Start date Start date
M

Mark Conway

I have a Windows 2000 Server that runs SQL Server and a
proprietary Application to gather real-time data. When
the network fails, and is then restored, the applications
cannot find the remote servers:

1. SQL is set to backup the databases onto a remote
machine, and the EventLog reveals that SQL could not
connect to the other server.

2. The application which connects to the proprietary data
source returns a connection error.

3. You cannot access external web pages or ftp to other
servers.

4. You CAN use Network Places to access other machines on
the network.

5. You CAN use Remote Terminal Services to log into this
machine.

--To fix the problem, I have had to reboot the server, and
all the applications run proerply, and I can access
external ftp and web sites.

Is there a networking configuration setting to
automatically reset the IP configuration when the network
fails?
 
Hi Mark,

Read your note several times and I think what the best course of action would be is to
determine why that server is not responding to network requests. Your mention of the "reboot"
to fix it seems to indicate there is a resource issue with the server and the rebooting frees that
up so the server can respond again. The fact that other machines on the network still function
normally indicates this is not a network problem per se. Could be a port on a switch that shuts
down due to a flood or some other reason.

The best thing to do at this point would be to examine the event logs closely for any signs of
resources depleting or other issues.

Hope this helps,
Gary
--------------------
'--'Content-Class: urn:content-classes:message
'--'From: "Mark Conway" <[email protected]>
'--'Sender: "Mark Conway" <[email protected]>
'--'Subject: Network Failure, SQL Failure
'--'Date: Mon, 2 Feb 2004 14:42:05 -0800
'--'Lines: 28
'--'Message-ID: <[email protected]>
'--'MIME-Version: 1.0
'--'Content-Type: text/plain;
'--' charset="iso-8859-1"
'--'Content-Transfer-Encoding: 7bit
'--'X-Newsreader: Microsoft CDO for Windows 2000
'--'Thread-Index: AcPp3chacDI0xjccTeyLwWrgB5VFLw==
'--'X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
'--'Newsgroups: microsoft.public.win2000.networking
'--'Path: cpmsftngxa07.phx.gbl
'--'Xref: cpmsftngxa07.phx.gbl microsoft.public.win2000.networking:53473
'--'NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
'--'X-Tomcat-NG: microsoft.public.win2000.networking
'--'
'--'I have a Windows 2000 Server that runs SQL Server and a
'--'proprietary Application to gather real-time data. When
'--'the network fails, and is then restored, the applications
'--'cannot find the remote servers:
'--'
'--'1. SQL is set to backup the databases onto a remote
'--'machine, and the EventLog reveals that SQL could not
'--'connect to the other server.
'--'
'--'2. The application which connects to the proprietary data
'--'source returns a connection error.
'--'
'--'3. You cannot access external web pages or ftp to other
'--'servers.
'--'
'--'4. You CAN use Network Places to access other machines on
'--'the network.
'--'
'--'5. You CAN use Remote Terminal Services to log into this
'--'machine.
'--'
'--'--To fix the problem, I have had to reboot the server, and
'--'all the applications run proerply, and I can access
'--'external ftp and web sites.
'--'
'--'Is there a networking configuration setting to
'--'automatically reset the IP configuration when the network
'--'fails?
'--'


--

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included
script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best
directed to the newsgroup/thread from which they originated.
 
Back
Top