Error checking access to the server based on token with infrastructure error

Question

I would appreciate help in the following:

I created a local group on our SQL 2008 server and added two Windows accounts "DOMAIN \ UserName". Then I added a local group to the database and granted read-only access.

Users try to bind tables using MS Access using and connecting to ODBC and get the following error. Users are not system administrators.

Date 6/30/2010 1:01:54 PM SQL Server Log (current - 30/30/2010 1:10:00 PM) Login Status Message Login failed for user DOMAIN \ UserName. Reason: access token based server access check failed with an infrastructure error. Check for previous errors. [CLIENT: 999.99.9.99] 06/30/2010 1:01:54 PM SQL Server Log (current - 7/1/2010 8:12:00)

Login

Message Error: 18456, Severity: 14, Status: 11.

Database Server: Windows Server 2008 R2 Enterprise System Type: SQL Server 2008 64-bit Operating System

Answer 1

Thanks for your reply.

. , MS . , . . . , . , , .

p.reinoso

Answer 2

Kerberos/windows AD. AD, , .

Answer 3

, , SQL-, SPN. , , sqlsrv1 websrv1, svcacct1, ( ) SPN, , AD .

setspn -A MSSQLSvc/websrv1.domain.local:1433 svcacct1

, sqlsrv1 ( MS SQL), svcacct1 websrv1, .

Answer 4

, (p.reinoso). Windows SQL. MyDomain\SQL_Admin, SQL Login . SQL-, .

Answer 5

, , , , (, PARENT\someGroup). , , " ", / . .

Answer 6

:

/ . - , , / db Sql Server. . .

Answer 7

/YourDomaninName \ServerName $ , . , , , , , .

1. Script Create Login ( Script, )

CREATE LOGIN [YourDomaninName\ServerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];

2. , , .

USE MyDatabase;
IF EXISTS (SELECT * FROM sys.DATABASE_principals WHERE name = N'YourDomaninName\ServerName$')
DROP USER [YourDomaninName\ServerName$];

3.

USE [Master];
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'YourDomaninName\ServerName$') 
DROP LOGIN [YourDomaninName\ServerName$]

4. Script,

CREATE LOGIN [YourDomaninName\ServerName$] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];

5. , 2. SSMS.