question

BanuManjappa-4436 avatar image
0 Votes"
BanuManjappa-4436 asked BanuManjappa-4436 commented

SQL Server Reporting issue after server Downgrade

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

sql-server-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered BanuManjappa-4436 commented

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?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@OlafHelper-2800

Hi Olaf,

Thanks for the response....The reason, SSRS is not initialized is for the reason that SSRS Enterprise edition o can not connect to Dev Database Report servers. And the reason we downgraded
it to Developer edition is because it is Dev Environment.

SInce nothing is changed in SSRS configuration, I guess Reverting DB Engine back to Enterprise edition should work.

Please Let me know

Thanks and Regards

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered BanuManjappa-4436 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Joyzhao-MSFT ,

No Changes was done in SSRS.Only the database engine where report server DB Resides was changed from Enterprise to Dev. Edition.

wanted to know,reverting Dbengine back to Enterprise edition would work or not.

Thanks and Regards
Banu Prakash M


0 Votes 0 ·