Take the 2-minute tour ×

Below is an abbreviated query I am trying to execute against LDAP using a linked server:

select * from openquery(ADSI,'')

The query runs fine, except when I change the "Domain controller: LDAP server signing requirements" security setting to "Require signing" on the LDAP server. When I do that, I get the following error:

Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing the query "" for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI".

The linked server ADSI is created using a domain account. Also, we would prefer not to use OPENROWSET if we can help it.

share|improve this question
add comment

1 Answer

Are you using TLS/SSL?

If you "Require signing", then the LDAP data-signing option must be negotiated unless Transport Layer Security/Secure Socket Layer (TLS/SSL) is being used.

See http://support.microsoft.com/kb/823659 for more information.

May be unrelated, but I noticed there is no explicit 'SELECT * FROM "LDAP://DC=MyDC,DC=MyOtherDC"' in the query portion of OPENQUERY

Good luck

share|improve this answer
add comment

Your Answer


