This is an old trap, if you lose the internet connection you no longer get resolution.
Do you have a server if so setup the DNS on it, if not what about the router is it DNS Capable, either way it will speed things up markedly.

>Checking the TCP/IP properties I see that I have defined a preferred and an alternate DNS server, both outside the LAN :)
>
>I always thought of a DNS a way to resolve addresses such as microsoft.com. How should I correct this? The SQL Server is inside the LAN.
>
>Thanks for the help.
>
>Alex
>
>
>
>>As per Sergey's query re: the DNS. Do you have a DNS server or are you using the router's DNS. also where is the SQL Server located, on the LAN or remotely.
>>
>>>We are using a separate switch. Fiber comes into a little box (don't know if that is the router) then goes to firewall then to switch to which the different PCs connect.
>>>
>>>Thanks for the help.
>>>
>>>Alex
>>>
>>>>Are you using a separate switch or the router ports for the network.
>>>>
>>>>>For some reason when we lose internet connection SQL Server does not respond to connections from the LAN. Does somebody know how to correct this?
>>>>>
>>>>>TIA,
>>>>>
>>>>>Alex