Connecting to SQL Servers with Different Domains RRS feed

  • Question




    I have 2 sql server database. SQL1 is in domain1 and SQL2 is in domain2. SQL2 MUST connect to SQL1 thru windows authentication. Is there any way to do this? Or can i use Linked Server and impersonate the windows authentication that can access SQL1?


    Please advise how.




    Wednesday, October 8, 2008 5:30 AM

All replies

  •   You will need to establish a trust relationship between both domains. For more information please visit BOL: Configuring a Domain Controller.


      I hope this information helps, 

    -Raul Garcia


       SQL Server Engine


    Thursday, October 9, 2008 6:06 PM