sql访问怎么检索ActiveDirectory中的数据

Question

rt
谢啦

Answer 1

string path = "LDAP://DC=Domain,DC=eg"; 
DirectoryEntry entry = new DirectoryEntry(path, user, password); 
SearchResult sResultSet = null; 
DirectorySearcher directorySearch = new DirectorySearcher(entry); 
directorySearch.SearchScope = SearchScope.Subtree; 
directorySearch.Filter = string.Format("(&(samAccountName={0})(memberof:1.2.840.113556.1.4.1941:=CN=Application A Group,OU=Application Groups,DC=Domain,DC=eg))", lookUpUser); 
searchResultSet = dSearch.FindOne();

Answer 2

EXEC dbo.sp_addlinkedserver @server = N'ADSI',@srvproduct=N'Active Directory Services', @provider=N'ADsDSOObject', @datasrc=N'FullDomain(如：corp.microsoft.com)'  --连接数据库EXEC sp_addlinkedsrvlogin 'ADSI', 'true'
select * from openquery
(ADSI,'SELECT * FROM ''LDAP://FullDomain''')