Domain Group Not Working In SQL

Domain Group Not Working In SQL

Don't let this one bite you! So you added your domain group to SQL permissions and you cannot login locally in SSMS but you can remotely? The pr

Changing PWDLASTSET in Active Directory
IIS with ASP.NET support check
Create Local Administrator Account Remotely

Don’t let this one bite you!

So you added your domain group to SQL permissions and you cannot login locally in SSMS but you can remotely?

The problem stems from the fact that elevation is required to connect properly however you do not see any of the normal prompts to elevate. You might see an error in the SQL logs stating that “Token-based server access validation failed with an infrastructure error, Login lacks Connect SQL permission.

Solution:
You MUST right click SSMS and “Run as Administrator” if you are running locally.

 

COMMENTS