Connections Timing Out

#1

I am running an application on MS SQL2000 SP4. I have 5 clients connecting to
the SQL server. Almost every night between 5

opm and 6:30pm, I lose the
connection to the server from the clients and I get a message about my
database possibly being compromised. Everything locks up and I must reboot
the client.

Has any one experienced this?

Fini2549

#2

Check to see if there are any scheduled jobs running at that time. Sounds
like someone is running a DBCC CHECKDB and placing the db in single user
mode.

--
Andrew J. Kelly SQL MVP

"Fini2549" <Fini2549 (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am running an application on MS SQL2000 SP4. I have 5 clients connecting
to
the SQL server. Almost every night between 5

opm and 6:30pm, I lose the
connection to the server from the clients and I get a message about my
database possibly being compromised. Everything locks up and I must reboot
the client.

Has any one experienced this?

Fini2549

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Connections Timing Out

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Connections Timing Out - 02-16-2007 , 10:24 AM

Re: Connections Timing Out - 02-17-2007 , 08:20 AM