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