What Is a UX Audit and How to Conduct One to Improve Your Website's Usability
July 31, 2024
SSPI handshake failed with error code 0x8009030c
The other day I was working in SSMS and connected to an instance. Pretty normal there. I later opened some window (I don’t recall exactly–perhaps a report or some db option) and was met with this error message. I could then do nothing in the database.
SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: 10.1.1.1].
This same error was found in the SQL Server log with the accompanying error message.
Error: 17806, Severity: 20, State: 14.
It turns out my Windows password had expired from the time I opened the instance to the time I was looking at something in the database. Once I reset my password, I was good to go.
Director of Data Solutions
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.