用SQL语句从AD中读取用户相关属性 从AD中读取用户的相关属性

参考原文链接：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'' ')