sqlserver创建链接服务器读取AD域信息

以下内容已在SQL2008上测试成功。

1、添加链接，执行如下语句

EXEC sp_addlinkedserver @server = 'ADSI', @srvproduct = 'Active Directory Services 2.5', @provider = 'ADSDSOObject', @datasrc = 'adsdatasource'

EXEC sp_addlinkedsrvlogin @rmtsrvname = 'ADSI', @useself = 'False', @rmtuser = '<DOMAIN>\<username>', @rmtpassword = '<password>'

EXEC sp_configure 'show advanced options', 1 reconfigure with override

EXEC sp_configure 'Ad Hoc Distributed Queries', 1 reconfigure

2、如果要删除，执行如下语句

exec sp_dropserver 'ADSI', 'droplogins' 

3、使用OpenQuery查询

SELECT * FROM OpenQuery(ADSI, 'SELECT  company,samaccountname,name,mail FROM ''LDAP://DC=<DOMAIN>,DC=com'&