通过OLE DB Provider for Microsoft Directory Services可以将身验证模式与AD/LDAP整合。
OLE DB Provider for Microsoft Directory Services: EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource' GO
SELECT [Name], SN [Last Name], ST State FROM OPENQUERY( ADSI, 'SELECT Name, SN, ST FROM ''LDAP://ADSISrv/ OU=Sales,DC=sales,DC=northwind,DC=com'' WHERE objectCategory = ''Person'' AND objectClass = ''contact''')