Posted by After migrating the SQL Reporting to a new server my reporting server got broken because of multiple reasons. One of these reasons was the logging of error: The feature: “Scale-out deployment” is not supported in this edition of Reporting Services.
This one is
easy to tackle.
Delete the old reporting service server key with the following query from your
Reporting Database table name dbo.keys:
NOTE: Please backup your Database before running this query!
|
1 2 3 4 5 |
#Old server name which was different from the new server delete from dbo.Keys where MachineName = 'SERVERNAME'; #Or if it is the same server name, the key wich not contains your Reporting service instance name. delete from dbo.Keys where InstanceName = 'MSSQLSERVER'; |
thanks worked for me, i was migrating SQL 2014 to 2016
Good to hear.
Thanks for your feedback.
i tried to delete but re-appears for me everytime once I drop that record, not sure why..
and I always see both the keys in there after i stop and restart the SSRS services.
Any help? pls
AJ