I have been trying to connect SQL Server 2005 via Linked Server connection to Active Directory and keep getting this error:
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT personalTitle, manager, name, employeeid, distinguishedName
WHERE objectClass = 'user' AND objectCategory = 'Person' " for execution against OLE DB provider "ADsDSOObject" for linked server "ADSI".
I have the linked server connection and it tests out great. I have also made sure the service SQL Server (MSSQLSERVER) is running on an account within Active Directory which has admin access. I have also added that user into the linked server properties as a user who is impersonated. The only thing I have not yet done is added the same login to the other services which have MSSQLSERVER after them. For instance SQL Server Agent, SQL Server Analysis Services, SQL Server FullText Search, etc.
I have been trying to find a resolution for this for the past week and a half and it appears Microsoft does not have a good fix for it. Any help would be great.