Introduction to ASP.NET Core Blazor Server
October 31, 2023
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.