Post reply

Cross Domain User Authentication

  • August 4, 2017 at 9:35 am

    #343949

    Hello,

    I have a 2 domain environment with a forest trust in place.  Domain A runs a program that has it's SQL database residing on a server also in Domain A.  I have been asked to install this program on Domain B, and link the users to the database on Domain A.  When I attempt to create the user logins through the SQL Management Studio, I cannot add users from Domain B.  When I search for the users, it recognizes Domain B, but I cannot expand it to select the users/groups I would like to add.  Any advice on how to proceed?

    Thanks,

  • August 4, 2017 at 9:47 am

    #1954166

    Sounds like you and/or the SQL service account don't have permission to view the users in the other domain, or the trust between isn't high enough. This'll be a network issue rather than anything, so you'll need to talk to your network support team.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 4, 2017 at 1:24 pm

    #1954195

    have you tried just scripting out the login creation?
    CREATE LOGIN [DomainB\ADaccountName] FROM WINDOWS;

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

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