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/
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy