I have an ADAM instance I'm using for application group membership, using
bind redirection. I need to be able to query it from SQL Server, installed on
the same machine. I have a llinked server, 'ADSI', setup which I have
previously used successfully to query the main AD. Linked Server is setup to
use a known account 'AD_Reader' to query with, and the account has been added
to the 'Readers' role in the ADAM instance.
when I run the following query, I get the indicated error message. What am I
doing wrong?
SELECT objectSID, samAccountName
FROM OPENQUERY(AD_Test,
'SELECT objectSID, samAccountName
FROM ''LDAP://AS4:50000/DC=hannover,DC=com'' where objectCategory =
''Person'' and objectClass = ''User''') AS derivedtbl_1
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ADsDSOObject" for linked server "AD_Test" reported an
error. The provider indicates that the user did not have the permission to
perform the operation.
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT objectSID, samAccountName
FROM 'LDAP://AS4:50000/DC=hannover,DC=com' where objectCategory =
'Person' and objectClass = 'User'" for execution against OLE DB provider
"ADsDSOObject" for linked server "AD_Test".