Monday, February 27, 2012 5:45 PM
In the SCCM console under this location: computer management-reporting-reporting services-all reports I have tried to create a new subscription. It fails each time. Based on the error I get below it seemed like a permission issue on the DB. So I added my Admin ID to be a DB_OWNER and I still get this error:
Error: Save subscription to server
The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.
If I'm a DB owner how do I make this work?
Monday, February 27, 2012 9:46 PMModerator
Have you setup a user account execute these reports? If you have not done that yet, then you must do that first.
Monday, February 27, 2012 11:27 PM
Yes, I used my Admin ID. I added that to SQL and then gave that same ID DB_OWNER rights. My Admin ID is also an Admin on the SQL Box itself.
Monday, February 27, 2012 11:40 PMModerator
That does not create an execution account for SSRS. Read this article. http://msdn.microsoft.com/en-ca/library/ms156302.aspx
Tuesday, February 28, 2012 10:21 PM
You need to save account credentials for the data source name that the report uses. When a report executes as a subscription, it needs to have a security context. http://msdn.microsoft.com/en-us/library/ms160330.aspx
Saturday, March 10, 2012 4:40 PMModerator
I wouldn’t set this up for one report only, I would do it for the whole SSRS site.
In a nutshell, use the report server credentials, grant if db_datareader right within the db.