June 25, 2008 at 3:18 am
Hi,
We get a bunch of errors from time to time (once a month) and it seems that in that period of time nobody is able to login in ..
On the other hand I've seen that in one of the trace files (the default one..) there is absolutely nothing written in that period of time, we have a 'gap' of 20 minutes in our case.
Below are the errors we get :
Message
[298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001]
Message
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
Message
[298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
Message
[382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
I would appreciate if anyone can help in this matter,
Kr,
R
June 25, 2008 at 7:38 am
Is the attempted login originating from the server, or from a remote computer?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 25, 2008 at 8:25 am
From the server.
kr,
R
June 25, 2008 at 9:27 am
In that case, I'm going to hazard a guess that the server is slammed during that time. Check for CPU peak/RAM use peak right before that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 25, 2008 at 9:31 am
What authentication are you using, Windows/SQL or both
Also is the target Database in SINGLE user Mode or something.
There could me many things to consider.
Maninder
www.dbanation.com
May 7, 2015 at 3:14 pm
Did you ever get an answer to this problem? I have the same issue.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply