多种途径访问AD

sqlserver:
    创建linkserver
     安全性->链接服务器 -> 添加
     在其他数据源中选择提供程序 OLE DB Provider for Microsoft Directory services
     在查询分析器中
SELECT createtimestamp,title,mobile,telephoneNumber,facsimileTelephoneNumber,AdsPath,mail,department,sn,displayName,sAMAccountName FROM
                 OPENQUERY(链接服务器名称,'SELECT createtimestamp,title,mobile,telephoneNumber,facsimileTelephoneNumber,AdsPath,mail,department,sn,displayName,sAMAccountName FROM ''LDAP://DC=域的名称,DC=COM''  WHERE objectClass = ''User''')

待续...