troubleshooting Question

windows authentication from a different domain for SQL Server Login

Avatar of bozer
bozer asked on
Microsoft SQL ServerWindows Server 2008
3 Comments1 Solution301 ViewsLast Modified:
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
Ryan McCauley
Senior Data Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros