ADSI

ADSI linked server needed to run/connect as a network service account

http://forums.asp.net/p/588030/1456487.aspx

" ... This was quite an old post. But I'll just confirm that the issue is probably due to the service account that MSSQLSERVER service runs under needs to have domain access to query ADSI. Use a domain account to run the service and you should be fine, see info here: http://www.codeproject.com/aspnet/LikeDataStores.asp ..."

Other ...

Check that you have (sql) rights ...

Check entries in the hosts and lmhosts files


Currently working ADSI query

SELECT TOP 30 *
FROM OPENQUERY ( ADSI,
'SELECT givenName, SN, displayName, mail, sAMAccountName,Department, Division, EmployeeId
FROM ''LDAP://serverwithfulldomain/baseDN''
WHERE objectCategory = ''Person'' AND
objectClass = ''user''')
Fully Qualified Name

Datalanbiguity

Datalanbiguity

(noun, intransitive) : The act or state of being held responsible for performing activities of which you are not aware and for which the instructions are not forthcoming from those aware of the activities which are to take place