Query Active Directory from SQL Server

- March 09, 2010

If you need to access some Active Directory information from SQL Server you can use the openquery command with the ADSI provider, below is an example for doing that

select *

from openquery(adsi, '

select displayName

from ''LDAP://dc=comunidadwindows,dc=org''

where objectCategory = ''Person''

and

objectClass = ''user''

and sAMAccountName = ''useraccountname''

You also must consider the segurity required inside Active Directory to allow the SQL Server Service account access to the corresponding OU, you can do it with Active Directory Users and Computers with Advance Features Enable and choosing the Security menu as show in the following figure: