Error to RUN select against Active Directory

Asked Jun 02 '17 at 18:55

Active Oct 22 '21 at 14:01

Viewed 538 times

I want to run this query:

SELECT top 10 *
FROM openquery(ADSI, '       
    select  *    
    from ''LDAP://londcrwc02.adslocal.net:389/ dc=adslocal,dc=net''      
    where objectCategory = ''Person''      
    and objectClass = ''user''      
')

In two different servers, the first server can run the query perfect but the second one has this error:

Msg 7321, Level 16, State 2, Line 163
An error occurred while preparing the query "
select *
from 'LDAP://londcrwc02.adslocal.net:389/ dc=adslocal,dc=net'
where objectCategory = 'Person'
" for execution against OLE DB provider "ADsDSOObject" for linked server "ADSI".

edited Oct 22 '21 at 14:01

Toni

1,555
4
15
23

asked Jun 02 '17 at 18:55

Amir Reza Mehraban

2

Is the Linked Server setup on the 2nd server? – SS_DBA Jun 02 '17 at 18:57
Yes, of course the linked server in both servers created by SQL Admin, – Amir Reza Mehraban Jun 02 '17 at 20:54
Sounds like it is related to this issue https://stackoverflow.com/questions/7741528/linked-server-ldap-msg-7321 – tgolisch Mar 02 '23 at 14:49

Error to RUN select against Active Directory

0 Answers0