SSPI handshake Errors in SQL error logs (Repeated )

• aby_dvd

  Ten Centuries

  Points: 1310

  More actions

  June 21, 2011 at 5:44 am

  #149122

  We are receiving many repeated errors in the standalone server with the below description :

  "SSPI handshake failed with error code 0x8009030c ......"

  The cause may be due to in-correct registry values .

  We tried repairing the SQL Server Installation , but it didn't work for us .

  Please let us know if you have any further information on this .

  Please cc to my id also : abhishek.dwivedi@us.pwc.com

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 21, 2011 at 7:10 am

  #1341816

  It could be an AD issue. Check the AD logs and look for failovers: it takes a while to invalidate all the cached kerberos tickets.

  -- Gianluca Sartori

• aby_dvd

  Ten Centuries

  Points: 1310

  More actions

  June 21, 2011 at 7:34 am

  #1341834

  Will the re-boot of the server work in resolving the issue ???

  Thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 21, 2011 at 8:06 am

  #1341853

  Can't say. You don't have much to loose, after all. Give it a try.

  -- Gianluca Sartori

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 21, 2011 at 8:19 am

  #1341865

  I believe that this error occurs when someone has changed the password on their Windows login but still has a connection to SQL Server from before the change.

  John