sql访问怎么检索ActiveDirectory中的数据
rt
谢啦
[解决办法]
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();
[解决办法]
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''')
