Here's a weird one for all of you...
- From: "RM" <rm@xxxxxx>
- Date: Wed, 6 Sep 2006 15:45:28 -0700
Hi,
Let me outline what I have and maybe someone will know how to react to what
is happening to my system.
Server: Windows2003 Standard
SQL: SQL 2005 Demo
and
SQL: SQL 2005 Processor Licensed (connecting via port 14330)
Additional Major S/W on that server: Sophos
We have run out the demo time frame and installed a 2nd instance of SQL 2005
on the same server only connecting on port 14330. I can connect to either
instance without any issues.
Problem: Sporadically (it seems to be very random) connections that are
"live" to the demo sql 2005 begin to "time out" when accessing the db for
just simple recordsets. It appears to start with one then two and then like
a wave suddenly nearly every pc hits a "time out" on a db access.
We shut down and reboot the server and all works fine again. Sometimes, if
we wait long enough, the "time outs" stop and everyone slowly gets back
connected and the issue goes away. But we obviously cannot rely on that.
This has happened 2 times in 1.5 days and we're fearful that it will just
keep happening. We installed SP1 on the new SQL 2005 instance.
Can anyone venture or hazard a guess as to what might be killing the
connection? We have looked to see if there was something happening at the
same time the time out's are occurring but find nothing.
HELP!
Thanks very much for any help,
Rich
.
- Follow-Ups:
- Re: Here's a weird one for all of you...
- From: Robinson
- Re: Here's a weird one for all of you...
- Prev by Date: Re: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
- Next by Date: Re: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
- Previous by thread: Re: Connect to SQL2000 & SQL 2005
- Next by thread: Re: Here's a weird one for all of you...
- Index(es):
Relevant Pages
|
