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 '12 at 05:23 PM in Default

Kirman1 gravatar image

Kirman1
181 11 13 17

(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 '12 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 '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)
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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x536

asked: Nov 21 '12 at 05:23 PM

Seen: 735 times

Last Updated: Nov 26 '12 at 01:55 AM