I am able to run a query against AD successfully in Management Studio; however, when I run the same query in reporting services I received an error. TITLE: Microsoft Report Designer ------------------------------ An error occurred while executing the query. 'ADsDSOObject' failed with no error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14). ------------------------------ ADDITIONAL INFORMATION: 'ADsDSOObject' failed with no error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14). (System.Data) ------------------------------ BUTTONS: OK ------------------------------Sonya

Hi Sonya, If you are running SSRS 2008, applying sp2 is to solve this issue. Open http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17 to download the sevice pack. For other version, provide more details here so that we do futher research. thanks, Jerry

Unfortunately, running SQL 2005Sonya

What are the security configurations set on your data source connection? This error was probably a permission issue. The security contexts may be different when you ran your query in SSMS and report designer.Please remember to mark the replies as answers if they help and unmark them if they provide no help