This is will be my first SSRS migration and please bear with me if some points don’t make any sense.
I need to migrate the Reporting server but need to keep the same name so that the reporting URL don’t change.
Server A – Has the database and the reporting databases
Server B only has the reporting server installed.
Server C- New SQL Server will be installed with all the databases
Server D will have the reporting server installed.
Below is a summary
• Backup SSRS databases on source server • Backup Encryption Key on source server • Restore SSRS databases on target server • Restore Encryption Key on target server • Remove old server name from the Keys table on the target server
My confusion lies with the
What if I want the new server (Server C and Server D) to have the same name of Server A and Server B hence my reporting Web Service URL and the Web Portal URL don’t change.
My thought process was Rename Server A and Server B before migration and name Server C and Server D with the old name of Server A and Server B.
After that the Web Service URL and the Web Portal URL will pick up the default name which will be the old one. Please correct me if I am wrong and is there any thing else that I need to be aware of which might break the reporting
- After the migration do we need to move the rds files from the old server to the new server as well and since the names are the same so do we still need to modify the data sources?