Accessing Database from Different Domain

• jpinylo

  SSC Rookie

  Points: 26

  More actions

  July 27, 2017 at 1:51 pm

  #331996

  Hello,

  I currently work in an environment with 2 separate domains.  On Domain A, we have a program that all users run, with the SQL DB for that program residing on an SQL server also on Domain A.  I have been asked to install this program on Domain B with it having access to the original DB on Domain A.  I have created a trust between the Domains, but am unsure how to proceed from here.  Any help would be greatly appreciated.

  Thanks

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  Follow

  July 27, 2017 at 3:28 pm

  #1953117

  if the trust is setup, you can add the active directory logins to the instance just as you would if they were from domain A:
  CREATE LOGIN [DomainB\loginname] FROM WINDOWS ;

  then create the user in the database
  CREATE USER [DomainB\loginname] FOR LOGIN [DomainB\loginname];