My company is currently going through a data center migration. We are now down to the SQL Servers and this includes SSRS. The bad thing that is going to hit us is the current SSRS server is being migrated to a new domain. So all users/groups that have access to SSRS are in DomainA and after the migration the SSRS server will be in DomainB.
All user and groups were migrated from DomainA to DomainB, supposidly using the preserve SIDs. During a test we could not get this to work.
So DomainA\User1 does not work when server is changed to DomainB.
We have over 70,000 combinations of user permissions and group permissions across all of our reports.
Does anyone have any suggestions or ideas on how we can properly migrate this server from DomainA to DomainB without having to manually duplicate the security settings.
Note: This is a virtual machine and is being replicated from one VMWare cluster to one on the new network and then will be dis-joined from DomainA and joined to DomainB. Service accounts will be changed to DomainB and backup of encryption key will be restored after service account is changed.