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=M