When you use opendatasource to query something, you may get the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
This may be caused by service user delegation. Because of the double hop issue, the ticked is not passed to the other machine.
If this is the case, to solve the problem, with the help of domain admins, give the delegation to SQL Server Service account. By default accounts do not have this delegation.
The error message is like this.
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
The screen below shows the delegated SQL Server service account delegation property.
After setting, ticket must be renewed. It can be renewed manually or timeout period will be enough for renewal.
No comments:
Post a Comment