• Kenneth, thanks for the article. couple of points: are you sure the SQL restart is necessary to get this working, and the error you will often see returned with the double hop scenario is 'cannot generate SSPI context'

    Heres another good source on kerberos, linked servers and double hop

    http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx.

    Has anyone got this working when the first hop is to SQL server and the second to AD itself (i.e. an ADSI linked server set up)

    ---------------------------------------------------------------------