Groups | Blog | Home
all groups > sql server connect > november 2003 >

sql server connect : SQL Server goes down when internet is disconnected


Daniel Jorge
11/3/2003 12:29:53 PM
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

rboyd NO[at]SPAM onlinemicrosoft.com
11/4/2003 9:14:00 PM
It could be a problem with the network itself. When the internet goes down
can you ping the SQL Server machine name. If not it could be related to the
way the switch is routing the traffic.

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button