hi

in my network some times sql server being disconnect and our client have to restart their systems becuase of reconnecting to sql .why this happen?

we use sql server developer 2005 both in server & in our client.

i wait 4 answer.

thanx.

I would start with a network trace (simultaneous) from client and server to see what happened on the wire when the problem occurred before doing anything else. If a client is running an app that requires SQL (just guessing from the problem description) and cannot connect (and needs a reboot to fix), assuming you didn't have to restart SQL the likelihood it's a client-side problem goes up. I'd also suggest the usual - remove apps that install network LSPs like 3rd party firewall, antivirus, and/or antimalware products to make sure none of them are destroying the connection prematurely.