Over a million developers have joined DZone.

Connection To Active Directory From SQL Server

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
FROM ''LDAP://Servername.domain.com''
WHERE objectCategory = ''Person'' AND objectClass = ''user''

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}