Let me describe situation:
SQL Server 2008 R2 - service running under AD account (not NETWORK SERVICE)
NAS installed on other computer (Windows 7) and running under AD account (different to SQL service account)
After starting NAS service error occurs in event viewer:
The Login Failed when connecting to SQL Server srvNAV.
and on SQL Server error occurs:
Error: 18456, Severity: 14, State: 11
Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.
We tried to set SPN for user, machine, service on both machines and add delegation on AD.
What's wrong and what we need to do to bring NAS to live?
Thanks in advance
0