Reconfigure SQL Server Reporting Services After Server Name Change

Error 1:

The service is not available.

Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database. Make sure the database is running and accessible. You can also check the report server trace log for details.

Error 2:

The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key.

Reconfigure SQL Server Reporting Services

You will need to reconfigure SSRS after a server name change.

• Go to “Reporting Services Configuration Manager”.
• Reconfigure “Database” section to point to the new server name and report database name “ReportServer”.
• Reconfigure “Encryption Keys” section. Create a Backup of the Encryption Keys on the old server, move the backup .snk file from the old server to the new server, and on the new server Restore the Encryption Keys from the backup .snk file.
• SSRS should now be accessible via http://newserver/reports.

Note: If the Encryption Keys backup option is grayed out, check to see if SQL Server service is running.