We are observing these below errors in our logs frequently and it gets fixed automatically –
Error: 18456, Severity: 14, State: 46. Login failed for user ‘sqllogin’. Reason: Failed to open the database ‘DBNAME’ configured in the login object while revalidating the login on the connection. [CLIENT: Ipaddress]
The client was unable to reuse a session with SPID ***, 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.
What is the cause of this,why this is occuring.
We can see multiple active sessions and long running selects at the same time.
Note – This brings the production down.