Can't run reports against the DB
-
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:
Save Subscription
Error: Save subscription to server
Errors
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?
Thanks.
mqh7
All Replies
-
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.
http://www.enhansoft.com/
-
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.
mqh7
-
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
http://www.enhansoft.com/
-
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
Steve
- Edited by Steve Thompson [ MVP ] Tuesday, February 28, 2012 10:38 PM added link
- Proposed As Answer by Garth JonesMVP, Moderator Saturday, March 24, 2012 6:49 PM
- Marked As Answer by Garth JonesMVP, Moderator Saturday, November 03, 2012 9:44 PM
-
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.
See the [Update} note here. J http://myitforum.com/cs2/blogs/sthompson/archive/2009/07/28/how-to-create-ssrs-subscriptions-for-configmgr-2007-part-2.aspx
http://www.enhansoft.com/
- Proposed As Answer by Garth JonesMVP, Moderator Saturday, March 24, 2012 6:49 PM
- Marked As Answer by Garth JonesMVP, Moderator Saturday, November 03, 2012 9:43 PM
.png)
