Post reply

Subscription owner change

  • April 8, 2011 at 8:23 pm

    #248687

    I have a mystery needed to resolved, I have thought through this about 2 days, still not have an answer.

    We have a reporting server that hosts reports that has subscriptions.

    The subscription is created by a former dba. His account got disabled, then the job failed because the user doesn't have server access. We have to reenable his account before I fix this.

    Now what I did is follow a tip http://blogs.msdn.com/b/miah/archive/2008/07/10/tip-change-the-owner-of-report-server-subscription.aspx.

    But the problem is I cannot see my username in the user table. I did all kind of thing such as loggin to the report server, and upload a file. I even create me as a system user in the reporting server. But my username is still not shown in the user table. One fact is I'm a member of local administrator group, could that be the reason I cannot show up in the user table as an individual user? But ther former dba is too, why his name is in user table?

    So I cannot update the ownerID in the subscription table like the above link told, because I cannot find what is my username in the user table?

    I ended up deleting the subscription, and recreated a new subscription. Now if in ssms reporting server, I right click the subscription I just created, and I can see the owner name is my user name there. But the strange thing is :

    when I query by join the subscription table with user table on ownerID=userID where the subsciptionID =the new subscription ID I just created, then I got the results : the login name is still the old dba's login.

    While now her account is still enabled, it runs fine, I don't know it will not work again if he is disabled in active directory.

    Why in ssms I cain see the subscription name is my username, but by do above joining above table, it's still his name,

    And I look at all the other tables, I cannot find where myusername is stored.

    Also I tried to login to use my account to create more new subscriptions under other reports, then I pull owneID and userID from the tables, it still tied to the former dba's username,

    any help about this?

    Thanks

  • March 16, 2012 at 6:12 pm

    #1460814

    Please help with case

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

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