Have created a linked server to active directory from SQL Server but getting a permission denied error when I try to query anything.
Under the security options for the linked server I have specified the connection to use a domain account which can query AD from powershell.
Should this account have any special permissions?
This is the error message I'm receiving from SQL
The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation.