SSRS 2008 R2 Changed active directory user name and now new subscriptions won't run
I had to change my login in active directory. After doing that all of my SSRS (2008 R2) subscriptions wouldn't run because the previous AD entry didn't exist. I had a tool to make those changes, but I still have the same issue when I create a new subscription. It says my AD login isn't recognized. How do I change that? I've googled it and found some hits, but nothing quite explains how to fix the issue for new subscriptions. Can I just go to the users table and change the old login to the new login?
Russell Fox
Hi there, try going into the configuration mgr on the machine where SSRS is running: Start -- All Programs -- Microsoft SQL Server 2008 R2 -- Configuration Tools -- Reporting Services Configuration Manager. Check that the Execution Account isn't using your old login.
ASKER
Thanks for the suggestion - there isn't an execution account used. Any other ideas? I've seen references to the user table in the ReportServer database. I actually see my incorrect login in there, but I haven't found any specifics on how to change it. I don't know if I can just type in the correct login or not. I've found references that show how to find the SID for logins, but then doesn't tell me how to change it.
Sorry, I've never messed with the internals like that, but here's a post that talks about deleting someone out of the Users table. Maybe delete yourself and then add yourself back in? Or it might be worth trying to just alter the table to the correct login, just be sure to back it up, first!
how-to-delete-user-in-ssrs
how-to-delete-user-in-ssrs
>> Can I just go to the users table and change the old login to the new login?
Nope, you shouldn't change users table but you need to change it in dbo.subscriptions table.
Before doing the update in dbo.Subscriptions table, kindly check the below things.
1. Ensure new user was created in SSRS and available in dbo.users table.
2. Update dbo.Subscriptions with new user id for all records having old user id..
Similar situation with working scripts available in MSDN page below..
https://blogs.msdn.microsoft.com/miah/2008/07/10/tip-change-the-owner-of-sql-reporting-services-subscription/
Nope, you shouldn't change users table but you need to change it in dbo.subscriptions table.
Before doing the update in dbo.Subscriptions table, kindly check the below things.
1. Ensure new user was created in SSRS and available in dbo.users table.
2. Update dbo.Subscriptions with new user id for all records having old user id..
Similar situation with working scripts available in MSDN page below..
https://blogs.msdn.microsoft.com/miah/2008/07/10/tip-change-the-owner-of-sql-reporting-services-subscription/
ASKER
Thanks - I'll try that this weekend. I have to put another migration to bed first.
It's odd that you can't just change the users table... my changed login wasn't added to active directory as a new user - just the login information was changed on the old user. My thinking (which I understand is wrong) was that if I changed the user table to match the new login information all of the subscriptions would still be under my name.
BTW, I had a tool and had already changed the owner on all of the subscriptions themselves so the only issue I had was creating new ones.
It's odd that you can't just change the users table... my changed login wasn't added to active directory as a new user - just the login information was changed on the old user. My thinking (which I understand is wrong) was that if I changed the user table to match the new login information all of the subscriptions would still be under my name.
BTW, I had a tool and had already changed the owner on all of the subscriptions themselves so the only issue I had was creating new ones.
Okay, fine. After changing the subscriptions table, kindly let me know how it goes..
ASKER
I started by trying to create a new user, but it says the user already exists. So even though my account shows my old login (initials), it is pointing to the correct active directory record with my new login. I'm getting an error code 15025
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.