Post reply

subscription owner change

  • January 14, 2014 at 4:59 pm

    #288329

    In SQL server reporting manager we created some subscriptions for some reports.

    The user who created the subscription - the owner is gone.

    So now we have some subscriptions failed.

    I searched on line there is a script that you can change the ownership from the old user to new user. Or you can delete the old subscriptions, and recreate them.

    http://blogs.msdn.com/b/miah/archive/2008/07/10/tip-change-the-owner-of-report-server-subscription.aspx

    But this sounds still not a very good solution , for the new user may be gone someday too, and we will have to do the same process. Manual creating those will be a lot of work too.

    Is there a way that I can use SQL service account of this reporting server to be the owner of subscription?

    Will replace the user with the service account in the script I mentioned above work?

    Thanks

  • January 16, 2014 at 4:48 am

    #1680592

    Given that the service account should be in sysusers, and that page you referenced updates based on userID, I would say that yes, you can do exactly what you're thinking of.

    HOWEVER... (You knew there had to be a caveat, didn't you?) I would recommend creating a brand new plain vanillia domain account that doesn't have the same perms as the service accounts. Give it the perms it needs to run the subscriptions, but don't give it anymore (just in case it's hacked) and use that account to do the subscriptions.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 16, 2014 at 10:13 am

    #1680749

    Thanks,

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply