x

SSRS - Subscription Owner

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:
1. Create a Subscription
2. Execute the Subscription (which inturn executes the SQL Job)

I want a User ID can perform the above 2 operations ONLY and not all Admin Operations.

Request your much needed help.

Thanks

more ▼

asked Nov 21, 2012 at 05:23 PM in Default

Kirman1 gravatar image

Kirman1
181 14 15 18

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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).

more ▼

answered Nov 21, 2012 at 05:42 PM

Kevin Feasel gravatar image

Kevin Feasel
6.1k 3 5 11

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, 2012 at 06:03 PM Kirman1
Like what Role I have to give to that User on DB and Report Server?
Nov 21, 2012 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, 2012 at 07:19 PM Kevin Feasel
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x561

asked: Nov 21, 2012 at 05:23 PM

Seen: 940 times

Last Updated: Nov 26, 2012 at 01:55 AM