Re: Howto troubleshoot login failure - State 11?
- From: changliw@xxxxxxxxxxxxxxxxxxxx ("Charles Wang [MSFT]")
- Date: Thu, 29 May 2008 10:30:21 GMT
Hi Jonny,
Thank you for your email response. From the error log, I found the
following error messages:
2008-05-27 21:56:22.37 spid60 The client was unable to reuse a session
with SPID 60, which had been reset for connection pooling. This error may
have been caused by an earlier operation failing. Check the error logs for
failed operations immediately before this error message.
After further research, I found that this is most likely the known issue
documented in this KB article:
FIX: You may receive error messages when you try to log in to an instance
of SQL Server 2005 and SQL Server handles many concurrent connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;937745
I recommend that you first install the hotfix to see if it helps. If you
have any other questions or concerns, please feel free to let me know.
Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
.
- References:
- Howto troubleshoot login failure - State 11?
- From: Jonny Bergdahl
- Re: Howto troubleshoot login failure - State 11?
- From: Chris Wood
- Re: Howto troubleshoot login failure - State 11?
- From: Russell Fields
- Re: Howto troubleshoot login failure - State 11?
- From: Jonny Bergdahl
- Re: Howto troubleshoot login failure - State 11?
- From: "Charles Wang [MSFT]"
- Re: Howto troubleshoot login failure - State 11?
- From: Jonny Bergdahl
- Re: Howto troubleshoot login failure - State 11?
- From: Russell Fields
- Re: Howto troubleshoot login failure - State 11?
- From: Jonny Bergdahl
- Howto troubleshoot login failure - State 11?
- Prev by Date: Re: Error: 18456, Severity: 14, State: 16.
- Next by Date: Re: xp_logevent and service broker queues
- Previous by thread: Re: Howto troubleshoot login failure - State 11?
- Next by thread: Re: Howto troubleshoot login failure - State 11?
- Index(es):
Relevant Pages
|