2

Every so often, my SQL Server 2012 throws the following errors:

Error (likely related to the one below):

Source: spid99

The client was unable to reuse a session with SPID 99, which had been reset for connection pooling. The failure ID is 46. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

Error: 18056, Severity: 20, State: 46.

Immediately before the error above (same timestamp):

Source: Logon

Login failed for user 'myUser'. Reason: Failed to open the database 'myDatabase' configured in the login object while revalidating the login on the connection.

Error: 18456, Severity: 14, State: 46.

My ASP.NET 4.5 website (consuming the DB) throws this error at the same time:

System.InvalidOperationException: Internal connection fatal error.

What may be causing these issues and how can I fix them?

  • 1
    could this be a duplicate of: dba.stackexchange.com/questions/41820/… – Edward Dortland Jan 7 '14 at 9:12
  • 1
    Looks like a duplicate to me. @Alex You might want to add details of your environment to the dupe (as a comment) so we can see if any common themes exist but TBH someone encountering this should probably get PSS to investigate – Martin Smith Jan 7 '14 at 9:25
  • @MartinSmith yes, added to that one too. Weird that there's virtually nothing else about this out there, yet clearly several people on SO/DBA-SE encounter it with various configurations. – Alex Jan 7 '14 at 22:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.