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

Question

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

Hasan Mosharrof 0

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

2 answers

Your answer

Answer 1

Seeya Xi-MSFT 16,586

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".

Hasan Mosharrof 0

Hi @Seeya Xi-MSFT

Updated but still the error exists

query

SELECT *
FROM OpenQuery
    (LDAP, 'SELECT * FROM "LDAP://DC=****,DC=****,DC=****,DC=de"
                    WHERE objectCategory = ''Person'' AND objectClass = ''user'' ')

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

Completion time: 2023-03-15T08:03:33.1164428+01:00

Hasan Mosharrof 0

tried with OPENROWSET as well same error code but different msg

SELECT TOP 100 * FROM 
OPENROWSET('ADsDSOObject', 'datasrc;',
'SELECT mail, displayName,givenname,distinguishedName, SAMAccountName, CN
FROM ''LDAP://DC=****,DC=****,DC=****,DC=de'' ')

error:

Msg 7321, Level 16, State 2, Line 8 An error occurred while preparing the query 
"SELECT mail, displayName,givenname,distinguishedName, SAMAccountName, CN
FROM 'LDAP://DC=****,DC=****,DC=****,DC=de' " 
for execution against OLE DB provider "ADsDSOObject" for linked server "(null)".

Seeya Xi-MSFT 16,586 Reputation points

2023-03-16T09:03:21.0766667+00:00

You can check the relevant logs to see if there are any related errors reported.

Answer 2

Hasan Mosharrof 0

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!

umer 0 Reputation points

2024-10-10T07:26:26.2466667+00:00

Msg 7321, Level 16, State 2, Line 12

Share via

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

2 answers

Your answer