We are trying to set up a generic reporting login for SSRS2005, but cannot get it to work properly. If i use my network login on the data source, the reports run just fine, and I can view them from the Report Manager. If I use the login we set up, we get this error: An error has occurred during report processing. Query execution failed for data set 'Dataset1'. For more information about this error navigate to the report server on the local server machine, or enable remote errors before I go the route of setting this login up exactly the way I am, then start removing it from groups until I can see which group is driving this, I thought I would check here...

Hi, Please make sure the user name and password has set correctly in your database, you could open the SSMS to login in to see whether the user is valid. Please have a try and give the feedback. Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, Please make sure the user name and password has set correctly in your database, you could open the SSMS to login in to see whether the user is valid. Please have a try and give the feedback. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.