Step 1:- Add a linked server for the Active Directory exec sp_addlinkedserver ‘ADSI’, ‘Active Directory Services 2.5’, ‘ADsDSOObject’, ‘adsdatasource’ Step 2 :- Then follow the steps mentioned here for setting up permissions. Step 3 :- You can query the Active Directory listing (It lists only 1000 records. LDAP design is like that) SELECT * FROM… (0 comment)