<div>
Do the service account SQL is running under (or the account you are executing the query as) have access to query LDAP? &nbsp;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.
</div>


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.

<div>
You should configure you SQL server to run under a domain account and grant this domain account rights to query Ldap
</div>


You should configure you SQL server to run under a domain account and grant this domain account rights to query Ldap

<div>
I have configured the SQL services to run under the domain admin account. &nbsp;Where do I need to allow that uses to query the LDAP?
</div>


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?

<div>
<div class="content wysiwyg-content">
I just recently migrated all SQL 2005 services to a new server running Server 2008 R2. &nbsp;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. &nbsp;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). &nbsp;Any help or suggestions are greatly appreciated. &nbsp;Thank you in advance.<br />
<br />
&nbsp; <a href="https://filedb.experts-exchange.com/incoming/2010/09_w39/351919/LDAP-Error.jpg" target="_blank" title="LDAP Error (43 KB)"><img alt="LDAP Error" class="file-block lazyload" style="max-width: 437px;" data-src="https://filedb.experts-exchange.com/incoming/2010/09_w39/351919/LDAP-Error.jpg" /></a>
</div>
</div>


LDAP-Error.jpg

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.

  

LDAP Query with SQL 2005 on Server 2008 R2 Authentication

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.