Skip to content
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
SQL Server Blog Forum

Guide to SQL Server DBAs and Developers

  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • About Me
  • #SQLHelp
  • Training
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Oracle
  • Freelance
  • Disclaimer and copyright
  • DBA

    Login failed for user Reason: Token-based server access validation failed with an infrastructure error Login lacks Connect SQL permission.

    January 4, 2023

    Login failed for user Reason: Token-based server access validation failed with an infrastructure error Login lacks Connect SQL permission.   Login failed for user ‘localhost\windows_user’. Reason: Token-based server access validation failed with an infrastructure error. Login lacks Connect SQL permission. [CLIENT: <local machine>]   Check you have permission to the user, generally we will have permission. Check you are able to access SSMS local & remote. Most of the case issue will be – Check how many group has deny permission, definitely your login will be one of in the group.  For our case it was built in user group. SELECT sp.[name],sp.type_desc FROM sys.server_principals sp INNER JOIN sys.server_permissions PERM ON…

    Read More
    Muthukkumaran No Comments

Search Box

Advertisements

Categories

  • AlwaysON
  • AutoMon
  • Azure
  • Backup/Restore
  • Basics for freshers
  • DBA
  • Docker
  • DR/HA
  • Indexes
  • Internals
  • Junior DBA
  • Microsoft
  • Oracle
  • Performance
  • PowerShell
  • Questions
  • Scripts
  • SQL party
  • T-SQL
  • VLDB

Archives

Top SQL server blogs

  • Adam Machanic
  • Amit Banerjee
  • Brent Ozar
  • Gail Shaw
  • Grant Fritchey
  • Paul White
  • Pinal Dave
  • SimpleTalk
  • Sqlblog
  • SQLskills
Powered by RAR Web Solutions