Error 18056 Sev20 state 28

• PearlJammer1

  SSCrazy Eights

  Points: 8495

  More actions

  December 23, 2013 at 3:51 am

  #286496

  I am getting the following error in my logs:

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

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

  I believe that the key to understanding this error is understanding the failure ID which in this case is 28, which according to this link

  http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx

  means that id 28 = 'RedoLoginSessLang'

  Can anybody help me understand the meaning of this and what is happening on my sql server when this occurs ?

• Andrew G

  SSChampion

  Points: 12809

  More actions

  December 23, 2013 at 6:18 am

  #1675585

  There is a slightly better explanation of Error 18056 and why pooled connections raise those messages here: http://blogs.msdn.com/b/psssql/archive/2013/02/13/breaking-down-18065.aspx

  State 28 'RedoLoginSessLang' suggests that the session was attempting to change the Language property of the connection and failed.

  Find out what application was connecting as SPID 62 and check the connection string or connection properties for a modified Language value.