Openquery AD Permission Error

Question

When I try to connect to a domain with a linked server I get the following error:

"The provider indicates that the user did not have the permission to perform the operation."

Using LDAP Browser if it works. Any suggestions?

Thanks

Answer 1

Hi @Mario Garcia Tarifa ,

Thanks for posting here.

"The provider indicates that the user did not have the permission to perform the operation."

This tells us that the user in your linked server configuraiton doesn't have access to the AD / LDAP server to perform that query. You may need to engage your SA team to ensure the account configured in your linked server has the correct access to query AD / LDAP.

Could you please provide the complete query and error message? Then we could check further.

Only according to your limited information provided, you could have a try with below methods:

1. Make sure that linked Server was not missing the domain controller name. For example:“LDAP://DomainControllerName.com/OU=OrganizationalUnit,DC=DOMAIN,DC=NAME”.
2. Make sure that your accounts have the right to search & Read AD.
3. Check whether there is a configuration issue.

Please also refer below link and check whether it is helpful to you.
Query External LDAP Server from SQL Server

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.