My Subscriptions empty after domain migration
Hi Everyone, my company coleagues recently migrated Reporting Sevices 2005 from one domain to another and to a different machine but with the same name. They used P2V to migrate from physical to virtual but the guy who did this has now left. I have won the job of now sorting out the problems and although I am ok with SQL, Reporting Services is a bit of a mystery. The only problem I am awre of that still exists is that 'My Subscriptions' is empty. Myself and the test users have the correct permissions, Manage All Subscriptions, but cannot see any subscriptions. If I go in to the db and change the owner, which displays as the old domain name, to myself I can see the subscription, will test if others can tomorrow. The subscriptions all show as running ok so there isn't a problem there, just being able to view all subscriptions. Any ideas, pointers would be appreciated. Thanks in advance for any help.
August 2nd, 2011 3:10pm

Hi DeepBlueDiver, Thanks for your post. Based on the information you provided, your colleague had migrated Reporting Services from one domain to another, which would lead to the failure of reports subscriptions. The owner of the subscriptions was based on the logon account when they were created, so users couldn’t see all these subscriptions currently. To fix the problem, just replace the old OwnerID with the new one from Users table that matches the new domain user that you want to use. Please refer to the steps below: 1. Run SSMS, open Query Analyzer. 2. Click the Available Databases drop down list in the upper-left corner, select ReportServer. 3. Edit your T-SQL statements likes below: DECLARE @OldUserID uniqueidentifier DECLARE @NewUserID uniqueidentifier SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = 'OldDOMAINA\User' SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = 'NewDOMAINA\User' UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID Moreover, if the NewDOMAIN\User not exist in the Users table, you need to add/modify/delete something in the Reporting Server using that account and then it will appear in that table. More information about How to: Grant User Access to a Report Server (Report Manager), please refer to the link below: http://msdn.microsoft.com/en-us/library/ms156034.aspx If you have anything unclear, please feel free to let me know. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2011 11:23pm

Thanks for your reply. I have tried the above and this gives the users permission to see the subscriptions which they own as would be expected. However, for users with the 'Manage All Subscriptions' task, they still cannot see the subscriptions they don't own. Any further help would be welcome.
August 4th, 2011 3:05am

I may have been mislead here by the customer. They told us that in 'My Subscriptions' they could see all subscriptions and implied even those owned by other users were displayed here. I am not sure this is the case and will be doing a hands on test with them tomorrow to see if that is the case. I think the answer I got from Bill above fixes the problem with seeing your own subscriptions in 'My Subscriptions' and that is as good as it gets.
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2011 2:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics