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

 

[DrSql]

You can change security tab's around
Linked Server Properties

Dr.Sql
Good Luck.

 

[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 grately appreciated.

Jon

 

[DrSql]

What type of account you used to run SQL Server Service and agent? Our our linked environment some are set to local SQL account 'Be made using this security context:' and assign an account with an SA account. Or you can change by 'local server login to remote server login mappings' with impersonate.


Dr.Sql
Good Luck.

 

[jonwolds]

The Sql Server service and SQL Agent services are running under domain NT Accounts with sa permissions.

Can NT Accounts (domain or local) be used when selecting 'Be made using this security context' or is it only SQL Server Accounts?

Thanks
Jon

 

[DrSql]

In my case we have setup with SQL accounts, I will investigate further about it and keep you posted.

Dr.Sql
Good Luck.