dbTalk Databases Forums  

SQL Server goes down when internet is disconnected

microsoft.public.sqlserver.connect microsoft.public.sqlserver.connect


Discuss SQL Server goes down when internet is disconnected in the microsoft.public.sqlserver.connect forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daniel Jorge
 
Posts: n/a

Default SQL Server goes down when internet is disconnected - 11-03-2003 , 08:29 AM






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



Reply With Quote
  #2  
Old   
Rand Boyd [MS]
 
Posts: n/a

Default RE: SQL Server goes down when internet is disconnected - 11-04-2003 , 03:14 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.