AD login name changed, SSRS subscription owner refuses to change along with it?!
Posted on 2014-04-18
I've got a situation. Recently we changed our login usernames so mine went from domain\895 to domain\john (just changed name not new account). When I go to reporting services, all my subscriptions are gone from my view although they are still there. the issue is that reporting services still sees me as domain\895 when i'm now domain\john.
I can create a new subscription under domain\john but when I finish and go edit the subscription, the owner shows domain\895.
Now I can't get any subscriptions to run. They all error out with the message that user domain\895 doesn't exist or not recognized.
I don't care to transfer the ownership of existing subscriptions as there wasn't many to begin with and I can always recreate them. I just want the ownership changed over to my new login so I can create new ones. In the Users table, domain\895 exists but domain\john doesn't. I'm guessing this is a SID issue?
We're running SQL Server 2008R2 with Active Directory 2008R2. Any questions, please ask as I'm wanting to resolve this sooner than later since all users will be changing their login usernames in the near future.