Linked Server Problem

[jonwolds]

Hi,

I need to create an NT (Kerberos) Linked server across 2 domains.

Server 1 - DOMAINa\Test1 account

Server 2 - DOMAINb\Test2 account

Both accounts have sa permissions. Is it possible to map these accounts together so that the linked server works?

Thanks
Jon

 

[jonwolds]

When I select 'Be made using this security context' (on the Linked Server Security tab) and enter the details of a sql server account the linked server works correctly. However when I change this to a domain NT Account which has sa permissions on the remote box I recieve the following error:

Error 18456: Login failed for user etc.

This is strange as when 'Be made using the login's current security context' The domain NT Account will connect - suggesting Kerberos is configured correctly.

Any help would be greatly appreciated.

Jon