SQL Server Reporting issue after server Downgrade

Question

Recently ,In our environment, we Downgraded SQL 2017 Enterprise Edition to Developer Edition(uninstall and Re-Install).
Everything was fine, But with out our knowledge there is SSRS hosted on Different machine connecting to this server.
Since SSRS is enterprise edition and DB Engine is Developer, it has broken.

Now we want to downgrade SSRS to dev edition but, we are not able to generate the encryption key(It is Greyed out) in Report services configuration Manager.

To Fix this, i am planning to Revert the SQL Server back to Enterprise edition And then backup the encryption. Would this work ?

Thanks and Regards
Santhubt

Answer 1

we Downgraded SQL 2017 Enterprise Edition to Developer Edition(uninstall and Re-Install).

That wasn't a downgrade, only an edition change. You know you are not allowed to use Developer Edition in productive enviroment; it's only for develop & testing?

Since SSRS is enterprise edition and DB Engine is Developer, it has broken.

No, the edition doesn't matter here in anyway. There must be something else wrong. May you forgot to migrate/attach the ReportServer database? What does the SSRS configuration manager show?

Answer 2

Hi anonymous user ,

the encryption key(It is Greyed out)

"Change" and "Backup" will be disabled if your report server is not initialized. In Reporting Services, an initialized server is one that can encrypt and decrypt data in a report server database. Initialization is a requirement for report server operation. Initialization occurs when the Report Server service is started for the first time.

If initialization fails for some reason, the report server returns an RSReportServerNotActivated error in response to user and service requests. In this case, you may need to troubleshoot the system or server configuration. For more information, see How to Initialize a Report Server.

To confirm report server initialization, ping the Report Server Web service by typing https://<servername>/reportserver in the command window. If the RSReportServerNotActivated error occurs, the initialization failed.

i am planning to Revert the SQL Server back to Enterprise edition And then backup the encryption. Would this work ?

An important part of report server configuration is creating a backup copy of the symmetric key used for encrypting sensitive information. A backup copy of the key is required for many routine operations, and enables you to reuse an existing report server database in a new installation.

In addition to backing up the encryption key, you also need to use any supported method of backing up the SQL Server database to back up the report server database.

For more information, please refer to:
Migrate a Reporting Services Installation (Native Mode).
Backup and Restore Operations for Reporting Services.

Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.