connecting sql server in different domain using Windows authentication

• IT researcher

  SSCertifiable

  Points: 7567

  More actions

  April 10, 2013 at 1:08 am

  #272917

  hi,

  We have some client PCs connected to a server PC.Users in client PC access sql server 2008 r2 installed in server PC by using Sql authentication.Domains of server PC and client PC are different. Is there any way to use Windows Authentication in client PCs to connect to sql server provided we have same user account in server PC and client PC ?

  Thank you

• Perry Whittle

  SSC Guru

  Points: 233847

  More actions

  April 10, 2013 at 2:17 am

  #1605124

  There needs to be a trust relationship between the domains otherwise just use SQL Server authentication

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉