Hi, I have a very simple SSRS 2008 R2 report in Sharepoint 2010 with embedded data source and data set connections. When I edited the deployed report within Report Builder 3.0 launched within Sharepoint 2010. 2.4.2) The query executed fine within the data set component of this report returning data. 2.4.3) On clicking on the run button I get the following error; - "For more information about this error navigate to the report server on the local server machine, or enable remote errors ---------------------------- Log on failed. Ensure the user name and password are correct. (rsLogonFailed) ---------------------------- The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)" I have been viewing the Execution log as follows; - SELECT * FROM ReportServer.Dbo.ExecutionLogStorage ORDER BY LogEntryID DESC I understand that I should get more information from; - C:\Program Files\Microsoft SQL Server\MSRS10_50.<my instance name>\Reporting Services\logFiles\<today's log file> But I don't know what my search criteria within this log file is. Can any body help? I am currently looking at; - http://technet.microsoft.com/en-us/library/ms155836(SQL.100).aspx Kind Regards, Kieran. If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood

Hi Kieran, As you know, the error message is quite general, simply, I think you need to vierfy the user account and password that is used to open the report builder, and also verify the stored account or intergrated account to the SQL server. Furthermore, I think you may try to enable Anonymous access at the site level in Sharepoint 2010. You may refer to the articles below, http://msdn.microsoft.com/en-us/library/cc281309.aspx http://msdn.microsoft.com/en-us/library/ms365173.aspx http://msdn.microsoft.com/en-us/library/ms365173(SQL.90).aspx http://blogs.msdn.com/b/psssql/archive/2009/12/03/report-builder-and-firewalls.aspx At last, we need to look at the error log as you mentioned. Generally, the search criteria can be "Error" or "Failure". You may check the logs to gain more detailed information. Thanks, Eileen

Hi Eileen, Thanks for your reply. A sharepoint administrator has resolved the specific acces rights error. So my question is more orientated to finding out how to map the execution log table to the error log. I'll apply the advice " Generally, the search criteria can be "Error" or "Failure". You may check the logs to gain more detailed information." and see what I come up with.If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood