How do I change the owner of a subscription is SQL Server Reporting Services

Question

Hello,

The previous DBA here set up some SQL Server Reporting Services Reports to run automatically and email the report to users. When he left his accaount was disabled and now they don't work. The status on the subscription reads: "Failure sending mail: The permissions granted to user 'OURDOMAIN\old_DBA_Username' are insufficient for performing this operation."

Is there an easy way to change the owner, I have found the Owner field in the RS database in the subscriptions table and have though of just changing that, but don't want to break our production report service?

The other option of course is to create a new subscription and delete the old, but surly there is a better way.

Cheers,

Nige

Answer 1

Can't you modify the subscription?

http://technet.microsoft.com/en-us/library/ms157343.aspx

Answer 2

I ran into this issue before and found the answer in this article on Jeremiah Clark's blog.

Gist of it is, you're right on about updating the Owner field in the Subscriptions table of the ReportServer database with the new user.

Worked for me, anyway.