December 4, 2022 at 2:26 pm
Hi All,
One of our windows login is not working which is been configured in the connection string for website. Following is the error, it was working find for long time.
I have found following error an same account not connecting in SSMS as well. It is having db reader access, have given do owner not working but if I give sysadmin it is working fine. Any suggestion what could be the reason.
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>]
December 4, 2022 at 2:34 pm
December 6, 2022 at 10:55 am
Thanks for posting the solution
July 18, 2024 at 2:04 pm
Found the solution here http://www.batenict.nl/2020/04/03/token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission/%5B/quote%5D
Hi, thanks for posting that link. As of today, however, it leads to a 404 page. Does anyone have an updated or similar solution link?
Thanks for any help.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 22, 2024 at 10:18 am
search on "token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission"
most articles mention logins & service principal names.https://blog.sqlauthority.com/2015/08/19/sql-server-login-failed-for-user-reason-token-based-server-access-validation-failed-with-an-infrastructure-error/ Mentions checking for deny permissions
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply