Recently, I had to downgrade from SQL Server Enterprise Edition to Standard.
When I re-installed SQL Standard with the generic reporting services database, I restored the encryption key first, then restored the Enterprise edition reporting services database over the Standard Edition one.
When I tried to access the reporting services web site I got a rsReportServerNotActivated message and a click here message that brought up these search terms:
products ee transform aspx EvtSrc Microsoft ReportingServices Diagnostics Utilities ErrorStrings EvtID rsReportServerNotActivated ProdName Microsoft SQL Server Reporting Services ProdVer 11 0 3128 0
The way I solved this problem was to restore the Encryption Key again:
Now when I did that I ended up with a second error relating to having too many keys and that not being supported in Standard Edition. The exact error was:
The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
To solve that problem, you have to delete one or more of the keys:
C:\Program Files\Microsoft SQL Server\110\Tools\Binn>RSKeyMgmt.exe –l
Then run this command to delete all but the last key (which should be the one you restored):
C:\Program Files\Microsoft SQL Server\110\Tools\Binn>RSKeyMgmt.exe -r 132b8974-1503-4682-ae12-a1d836e3526e
Substitute the keys from your first command – but remember to keep the last key.
When done, run the first command again
C:\Program Files\Microsoft SQL Server\110\Tools\Binn>RSKeyMgmt.exe –l
And make sure that only one key is listed.
Darren Myher's Blog 