SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 127.0.0.1]

Question

got the below error while trying to connect to sql server 2005 using JDBC connection.

 Error: 17806, Severity: 20, State: 2.
 Logon       SSPI handshake failed with error code 0x8009030c while establishing 
             a connection with integrated security; the connection has been 
             closed. [CLIENT: 127.0.0.1]
 Logon       Error: 18452, Severity: 14, State: 1.
 Logon       Login failed for user ''. The user is not associated with a trusted 
             SQL Server connection. [CLIENT: 127.0.0.1]

MY connection URL:

jdbc:sqlserver://LOCALHOST:1433;DatabaseName=master;integratedSecurity=true

Answer 1

A five seccond Google search on "SSPI handshake failed with error code 0x8009030c" led me to this link. The third item in that thread links to a KB article, and the fourth links to a forum discussion.

Google can be your friend... :-)

Answer 2

Had the same exact message with this 0x8009030c code.

In my case, the user didn't have access to the sql computer from the network and I had a failure audit message indicating that (I think the same message also happens in other cases).

Go to: Local Security Policy -> Security Settings -> Local Policies -> User Rights Assignment -> Access this computer from the network -> add the user

It fixed the problem