Avatar of bozer
bozer
 asked on

windows authentication from a different domain for SQL Server Login

Hi experts,

I have two independent domains in my lab environment. (Lets call them DomainA and DomainB) What I need to do is to is to create a Login on SQL Server who is a member of Domain B. The issue is the Login has to be of a type 'Windows Authentication' and the Login name should represent a server in Domain A. So basically, it will be domainNameA\Server1A$

However, when I click the Search on SQL Server Login - New window, I only get the Directory of Domain B.

I completed the zone creation activities with DNS. What I need is an active directory integration of some sort to be able to complete the search for my Login name and set it as a 'Windows authentication' login type.

Thank you in advance
Microsoft SQL ServerWindows Server 2008

Avatar of undefined
Last Comment
Ryan McCauley

8/22/2022 - Mon
Radhakrishnan

Hi,

I think you need to enable "'Allow remote connections to this computer" within SQL management studio. It can be enable from right click the instance name (after login to SQL studio)>>properties>>connections.
David Johnson, CD

without a trust relationship it cannot be done and you must use a sql server login
ASKER CERTIFIED SOLUTION
Ryan McCauley

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck