DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Mark has posted 2 posts at DZone. View Full User Profile

Connection To Active Directory From SQL Server

  • submit to reddit
        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''  --AKA the full computer name of the AD server

//Then execute the openquery like this:

select * from openquery
FROM ''LDAP://''
WHERE objectCategory = ''Person'' AND objectClass = ''user''