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