Connection To Active Directory From SQL Server
Join the DZone community and get the full member experience.Join For Free
SQL Code to link to active directory from within SQl Server. ound by searching through a forum so can't claim I thought of it
//Follow this syntax: EXEC master.dbo.sp_addlinkedserver @server = N'ADSI', @srvproduct=N'Active Directory Services', @provider=N'ADsDSOObject', @datasrc=N'Servername.domain.com' --AKA the full computer name of the AD server //Then execute the openquery like this: select * from openquery ( ADSI,'SELECT name FROM ''LDAP://Servername.domain.com'' WHERE objectCategory = ''Person'' AND objectClass = ''user'' ')
Opinions expressed by DZone contributors are their own.