RE: Login Failed Reason: Token-based access failed

What was the error number, severity and state associated with this error
message. Did it happen to be:
Error: 18456, Severity: 14, State: 11.


If so verify that the windows account actually has a login to SQL Server via
Windows Authentication.

I've noticed in SQL Server 2008 when a Windows account doesn't have a Login
in SQL Server you get the following two messages in the SQL Server error log:

2009-09-14 06:45:29.42 Logon Error: 18456, Severity: 14, State: 11.
2009-09-14 06:45:29.42 Logon Login failed for user
'MyDomain\MyUserName'. Reason: Token-based server access validation failed
with an infrastructure error. Check for previous errors. [CLIENT:
172.16.7.103]

One adding a Login for the windows user the user is able to login.

Let me know if this fixes your problem.


"Joe K." wrote:


I have a SQL Server 2008 database server that I receive the following login
error.

Please help me resolve this issue.

Thank You,

Error:

Login failed for user 'HJKPK\FSDD3018'. Reason: Token-based server access
validation failed with an infrastructure error.
.

Relevant Pages

  • Re: Having trouble connecting to MSDE
    ... I was able to install MSDE and I see the icon on ... >allow SQL Server authenticated connection, ... >granted login provileges... ... windows account login ...
    (microsoft.public.sqlserver.msde)
  • Re: Disable Windows Authentication
    ... and only SQL Server Authentication is available for login? ... a Windows account must have a login or be a member of an group account with a login in order to connect. ... Removing Windows accounts you don't want to connect will effectively disable Windows authentication using those accounts. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL7 standalone
    ... domain account. ... Use local Windows account (from Win 2000 ... creadentials and don't have to login with different user) or SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Who has permissions to shut down SQL Server?
    ... If your Windows account have permissions to start and stop services ... > I am a DBA and has admin privileges to SQL Server. ... > login (just a login to SQL Server no other permissions) and from my machine I ...
    (microsoft.public.sqlserver.server)
  • RE: Token-based server access validation failed with infrastructure e
    ... I Have this issue running SQL Server 2008 and this message was in the log: ... "Login failed for user '%'. ... failed with an infrastructure error. ...
    (microsoft.public.sqlserver.security)
Loading