sqlserver 2017 error 7321, Level 16, State 2, Line 1

Question

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 though LDAP test connection shows successful and

Security Settings: Be made using the login's current security context

Msg 7321, Level 16, State 2, Line 1

SELECT
    *
FROM
'LDAP://DC=****,DC=company,DC=****,DC=de'
WHERE 
    objectClass = 'User'
" for execution against OLE DB provider "ADsDSOObject" for linked server "LDAP". 

Any guideline is much appreciated

Answer 1

Hi @Hasan Mosharrof,

You can use double quotes to enclose the LDAP path instead of single quotes. Then, you can use single quotes to enclose the value of the "objectClass" attribute.

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 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!