I Need To Make A Change With My IT Support! Call (225) 706-8414

SQL Server login with Management Studio Fails with Error 18456

You’re attempting to manage an SQL Server 2008 instance with Management Studio but are receiving an error 18456 when using AD authentication.

 

Error “Token-based server access validation failed with an infrastructure error” (event id 18456).

Solution

Follow these steps to debug the issue:

  1. First, make sure that you are logged in as a user with SA privileges.  Management Studio will only use AD credentials of the current session; you cannot specify an AD user and password like you can for SQL Server Authentication
  2. Check the Application event log for the 18456 event:

    If the error is “Token-based server access validation failed with an infrastructure error” the mostly likely culprit is UAC.  Close Management Studio, right-click and select Run As Administrator.  You’ll probably be able to login at that point.

 

Concerned About Cyber Attacks?

CLICK HERE >

Want to Migrate to the Cloud?

CLICK HERE >
Office 365

Ready to Experience Microsoft Office 365?

Want the latest IT news directly in your inbox? Subscribe now!