|
I have created 100 subscriptions with my User ID , few days back my User ID got locked and due to which the subscriptions failed. We have come up with a solution to create a User ID which is similar to Service Account and set its property that "password never expires". Here is the issue , my DBA doesn't want a User ID which has all the access as of Service Account. Can you please suggest what minimal rights are required to do the following: I want a User ID can perform the above 2 operations ONLY and not all Admin Operations. Request your much needed help. Thanks
(comments are locked)
|
|
EDIT - I just realized that I totally misread the question... Sorry about that. For executing Reporting Services subscriptions, the account must be in the RSExecRole database role. Make sure that you include the account in the RSExecRole for all of msdb, master, ReportServer, and ReportserverTempDB. From there, the SQL Server Agent account should have permissions to execute the job, so you shouldn't necessarily need to give your subscription account rights on the user databases. To create and manage subscriptions, there are internal Reporting Services roles: Report Builder/Browser (for individual subscriptions) or Content Manager (for all subscriptions). Kevin...it seems to be a huge topic..can you pls expalin to me..what steps I have to take to create a User ID on Report Server and DB server so that the User can only Create and Execute the Susbcriptions? Please help..
Nov 21 '12 at 06:03 PM
Kirman1
Like what Role I have to give to that User on DB and Report Server?
Nov 21 '12 at 06:04 PM
Kirman1
Updated the answer once I realized that I totally misread your question. This should hopefully be a bit clearer.
Nov 21 '12 at 07:19 PM
Kevin Feasel
(comments are locked)
|
