?
Solved

What is the Active Directory structure possibilites with these domain\users?

Posted on 2014-09-07
3
Medium Priority
?
239 Views
Last Modified: 2014-09-08
Currently: What I know - My company primary domain is 'A'.  

So user login looks like this:
1. A\User1
2. A\User2
3. A\User3

However,  when I am in my sql server logins in addition to the 'A\Userx' there is also 'B\Userx' which are external users and not part of the 'A' domain or even part of my company but are part of another organization entirely.
Since I currently am unable to view AD structure on the network please provide how the 'B' domain may be configured to gain access to the Sql Server instance.
0
Comment
Question by:rhservan
3 Comments
 
LVL 43

Accepted Solution

by:
kevinhsieh earned 2000 total points
ID: 40309217
B can be another domain in the same forest, or B can be another domain in a separate forest with a trust relationship.

See http://technet.microsoft.com/en-us/library/cc773178(v=ws.10).aspx
0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 40309236
Or depending upon how they are showing, is B the SQL servers name, I.e. they are local user accounts on the server itself?
0
 
LVL 53

Expert Comment

by:Vitor Montalvão
ID: 40309383
Domain 'B' is created in your organization?
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

598 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question