SSRS - Domain Migration and Subscription Ownership

Question

We are in the process of migrating from one domain to another and it seems users cannot see the subscriptions they created when they were logged in using the old domain credentials.

How can I, in bulk, make the users new domain credentials able to see the old domain subscriptions.

score 0 · Accepted Answer · answered Jun 10 '20 at 22:47

This was accomplished by running this in SSMS on the ReportServer dB

DECLARE @OldUserID uniqueidentifier
DECLARE @NewUserID uniqueidentifier
SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = 'old_domain\user'
SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = 'newdomain\user'
UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID

SSRS - Domain Migration and Subscription Ownership

1 Answers1