LDAP Linked Server query

Transact-SQL
1

Our Active Directory Linked Server name is LDAP
I am trying to run the following query
SELECT
top 100 *
FROM OPENQUERY (LDAP, '
SELECT
*
FROM
''LDAP://DC=,DC=company,DC=*,DC=de''
WHERE
objectClass = ''User''
') ad

getting the following error

Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "
SELECT
*
FROM
''LDAP://DC=,DC=company,DC=*,DC=de''
WHERE
objectClass = 'User'
" for execution against OLE DB provider "ADsDSOObject" for linked server "LDAP".

though LDAP test connection shows successful.

Any guideline is much appreciated

2

Somehow "Be use current security context" which is our AD account works for prod and doesn't works for test server
In sp_addlinkedsrvlogin we changed @useself=True to False and explicitly used username and password and recreated the LDAP. Then bingo!