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,

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 

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.

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.

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".

Sorry at this time. I dont have server version information.

i am surprised to say that why there was not failure code and state=8 in both 18456 and 18056. and spid 189 having select @@servername so i want to know am i right to say this is password mismatch problem (state=8).