Prev: [sqsrvres] CheckServiceAlive: Service is dead (Event ID: 19019)
Next: Unix Timestamp Conversion
From: Joe K. on 1 Sep 2009 10:58

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.
From: Linchi Shea on 1 Sep 2009 12:33
Check if the login is in too many AD groups. If so, remove some AD groups.

Linchi

"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.
From: Greg Larsen on 14 Sep 2009 19:08
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.
 | 
Pages: 1
Prev: [sqsrvres] CheckServiceAlive: Service is dead (Event ID: 19019)
Next: Unix Timestamp Conversion