Our system team warn us they detected unsecured connections when one of our linked server try to connet to the AD.
We managed to find the concerned request :
SELECT * FROM OPENROWSET('ADSDSOObject', 'adsdatasource';'LDAP_LOGIN';'Password',
' SELECT SAMAccountName FROM ''LDAP://ServerName''
WHERE SAMAccountName = ''NameTest'' and objectClass = ''user'' ')
After some research, we should use a syntax like
But we got the following :
for execution against OLE DB provider "ADSDSOObject" for linked server "null"
LDAP+636 - KO
LDAPS+636 - KO
LDAPS without port - KO
Our System team have also tested ad-hoc queries, including in the query all the domain information such as domain user, password, OU, CN, etc with the same result.
Also tried to import also the AD certificate in the trusted store of the server, same error.
Any clues about this problem ?