Thursday, June 17, 2010

Double-hop on SQL Server

How to set delegation for SQL Server?

How to resolve an error like:

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

It typically occurs when you use linked server – when you request from machine A something from machine B which then requests something from machine C.

Excellent text:

http://kendalvandyke.blogspot.com/2008/11/delegation-what-it-is-and-how-to-set-it.html

No comments:

Post a Comment