Step 1：Creating a Linked Server.
EXEC sp_addlinkedserver ‘ADSI’, ‘Active Directory Services 2.5’, ‘ADSDSOObject’, ‘adsdatasource’
Step 2：Creating a SQL Server Authenticated Login
EXEC sp_addlinkedsrvlogin @rmtsrvname = N’ADSI’, @locallogin = NULL , @useself = N’False’, @rmtuser = N’domain\Account’, @rmtpassword = N’Password’
Step 3：Querying the Directory Service.
SELECT * FROM OpenQuery(ADSI, ‘SELECT * FROM ”LDAP://OU=用户,DC=9846,DC=com” WHERE objectCategory = ”user” ‘)