Linked Server Accros Domains

  • Hi guys, so here's the scenario. SQL Server 2005. Box1 on Domain 1, Box2 on Domain 2. How can I add a linked server to Box2 from Box1. Has anyone got a checklist of what to look out for for me.\

    Thanks in advance guys.

  • Cross-domain connections are not that big of a deal. The servers need to be able to see each other's IP addresses and they need to be able to authenticate. If you are using SQL Authentication, the security is simple. If not, the NT login used for the linked server needs to work on the domain the server resides on. In most situations, you should have a trust relationship between the two domains and you can give the service account for one of the SQL Servers access to the other even though the server is on a different domain.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply