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:

image

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

imageThen 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.

Advertisements