I need some advice about Active Directory

Asked By newadmin 0 points N/A Posted on - 08/28/2011

Hello I'm working as a system admin.  I have the following two questions about Active Directory:

• When a user logs on to the system using the active directory, they log on to the AD(NTDS.DIT) database. Can you tell me where the AD(NTDS.DIT) database is located ? Is this separate from SQL server database? How do you access the AD(NTDS.DIT) database?
• How do you connect the AD(NTDS.DIT) database to SQL server 2008, if their databases are located at different locations?

Can some one explain the above two questions.

Thank you.

• Status: Open
• Question Views: 876
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Windows Networking

Best Answer by sami01

Go To Solution

Best Answer

Best Answer

Answered By sami01 0 points N/A #119637

I need some advice about Active Directory

Hello new admin,

For the question no 1 you mentioned, practically they don't physically log into the database, rather into Active Directory services or more specifically to the Domain. If they login to domain and for the local clients it is the local computer ( local System ) its not the Active Directory.

The location of AD ( default is C drive and the path is C :WindowsNYDS)NTDS.) is by default C: because you installed the O/S and other services by default in C: drive.

In response to your second question, how do you connect the Active Directory ( NTDS.DIT ) DB ( database ) to SQL server 2008 if the databases reside in different physical locations ?

That's a little bit confusing for me and also NTDS.DIT is NOT readable for SQL . 

That's the point. 

Hope my answers help you.

Thanks

About sami01

Questions
0

Answers
3

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/29/2011
• Question Category: Windows Networking

Answered By Peteranderson 0 points N/A #119638

I need some advice about Active Directory

Hi,

When a user signs into Active Directory it doesn’t basically logon to AD NTDS but it authenticates itself from the mentioned database, using LDAP authentication protocol. It lies in the system root/NTDS folder may be c:/windows/NTDS.  

Now how to connect to remote SQL server?

Hoping that you are already using a centrally managed SQL server and know how to configure SQL client, make active directory server as SQL client and check the connections. Now in administrative tools go to “Active directory Sites and Services” expand “Sites” and then “Servers” click “NTDS services”;  under server name, move to the “Connections” tab and add the SQL server name and other credentials.

Try to logon remotely.

About Peteranderson

Questions
0

Answers
50

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/03/2011
• Question Category: Windows Networking