Error 18056 state 8 and Error 18456 state 8: No failure code

Hi Experts,

As per the state 8 --> Password mismatch i found from 18056 and error 18456 state 8.

Here state 8 is the same in both the error messages. IS IT OK?

Here i didn't find failure code in 18056 error only state 8==> it means it points to password mismatch problem only?

here when i checked spid=189 with dbcc inputbuffer it was showing Select @@version not sp_resetconnection as it does in case of pooled connection. Is it ok?

Error 18056 state 8- The client was unable to reuse a session with SPID 189, which had been reset for connection pooling.

Regards,

July 25th, 2015 1:43am

http://blogs.msdn.com/b/psssql/archive/2010/12/29/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-part-2.aspx  will hep you..

How many connection in mssql 

Free Windows Admin Tool Kit Click here and download it now
July 25th, 2015 1:51am

Thank you for reply.

yes i have gone through this article before posting. Here i hv concern because there is no failure code. and spid=189 already existing and command was @@servername instaed of sp_reset_connection so i posted to this forum.

July 25th, 2015 2:33am

Thank you for reply.

yes i have gone through this article before posting. Here i hv concern because there is no failure code. and spid=189 already existing and command was @@servername instaed of sp_reset_connection so i posted to this forum.

Free Windows Admin Tool Kit Click here and download it now
July 25th, 2015 3:12am

Rather than starting in the middle, can you tell the full story of what happened? And please post the full text of message 18056, as it includes a failure code. And, yes, we want "SELECT @@version".

July 25th, 2015 4:22am

Hello it varies and totally different(hence required your version details) or can you re-produce & paste the screenshot ,also  check in the SQL errolog.
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2015 2:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics