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,