locked
Connecting to SQL Servers with Different Domains RRS feed

  • Question

  •  

    Hi,

     

    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.

     

    Thanks,

    cherriesh

    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

      SDE/T

       SQL Server Engine

     

    Thursday, October 9, 2008 6:06 PM