Change Report Owner

We had a person create over 200 report subscriptions and they are
showing up as the report onwer. No that this person has left and their
domain account has been deleted we have found that the SSRS 2005
report subscriptions are now failing.
How do you change the report subscriptions owner to someone that still
exists within the organisation? Or what else would be causing this
issue?
TIAOn Sep 5, 1:56 am, white...@.gmail.com wrote:
> We had a person create over 200 report subscriptions and they are
> showing up as the report onwer. No that this person has left and their
> domain account has been deleted we have found that the SSRS 2005
> report subscriptions are now failing.
> How do you change the report subscriptions owner to someone that still
> exists within the organisation? Or what else would be causing this
> issue?
> TIA
You are correct in assuming the subs are failing due to deletion of
the report owner's account. The same thing happened to us.
You will need to do one of two things: 1) have a current valid user
recreate all of the affected subs or 2) update the OwnerID value in
the Subscriptions table to a current valid user id.
What we did to eliminate this happening every time someone left was
create a generic "SubscriptionOwner" user account and amended the
stored procs (CreateSubscription And UpdateSubscription) that create
subscriptions so that the creating OwnerID value in the Subscriptions
table is replaced with that of the "SubscriptionOwner".|||On Sep 6, 2:55 am, toolman <t...@.infocision.com> wrote:
> On Sep 5, 1:56 am, white...@.gmail.com wrote:
> > We had a person create over 200 report subscriptions and they are
> > showing up as the report onwer. No that this person has left and their
> > domain account has been deleted we have found that the SSRS 2005
> > report subscriptions are now failing.
> > How do you change the report subscriptions owner to someone that still
> > exists within the organisation? Or what else would be causing this
> > issue?
> > TIA
> You are correct in assuming the subs are failing due to deletion of
> the report owner's account. The same thing happened to us.
> You will need to do one of two things: 1) have a current valid user
> recreate all of the affected subs or 2) update the OwnerID value in
> the Subscriptions table to a current valid user id.
> What we did to eliminate this happening every time someone left was
> create a generic "SubscriptionOwner" user account and amended the
> stored procs (CreateSubscription And UpdateSubscription) that create
> subscriptions so that the creating OwnerID value in the Subscriptions
> table is replaced with that of the "SubscriptionOwner".
Thanks for the advice.
However, I have changed the OwnerID in the Subscriptions table but
when I edit the subscription through report manager it still shows the
old username as "Owner:", but if performing a search through the
databse itself it doesn't show any where. I even tried renaming the
UserName field in the Users table, but the name still shows under
"Owner:" in Report Manager.
Any more help would be appreciated.