参考原文链接:http://www.myexception.cn/sql-server/1011477.html
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'
EXEC sp_configure 'show advanced options', 1
reconfigure with override
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure
SELECT [NAME], ADsPath [DN], Company [comp]
FROM OPENQUERY( ADSI,
'SELECT Name, ADsPath, COMPANY
FROM ''LDAP://10.10.1.7/DC=xmb,DC=cstnet,DC=cn''
WHERE objectCategory = ''Person'' AND
objectClass = ''user''')
SELECT * FROM OpenQuery(ADSI, 'SELECT * FROM ''LDAP://10.10.1.7/DC=xmb,DC=cstnet,DC=cn'' WHERE objectCategory=''user'' ')