mjfox1725
asked on
LDAP Query with SQL 2005 on Server 2008 R2 Authentication
I just recently migrated all SQL 2005 services to a new server running Server 2008 R2. I had a report that connected to the LDAP catalog to generate an employee list with phone numbers, extensions, cell phone number, email addresses, etc. When I test the connection of the linked server it tests fine but when I execute the query I get the following error (see attached image). Any help or suggestions are greatly appreciated. Thank you in advance.
Do the service account SQL is running under (or the account you are executing the query as) have access to query LDAP? It looks like you may need to run the query with a login tied to a domain account to retrieve this information or set the SQL service to run as a domain user if you are using SQL authentication.
You should configure you SQL server to run under a domain account and grant this domain account rights to query Ldap
ASKER
I have configured the SQL services to run under the domain admin account. Where do I need to allow that uses to query the LDAP?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.