Post reply

Accessing Database from Different Domain

  • 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

  • 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];

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

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