The feature “Scale-out deployment” is not supported in this edition of Reporting Services

Step1 :Connect to SSMS

Step2: Open New query window 

Step3: run below query

Use Report server

go

Select * from Keys

Step4: List all the keys that needs to be deleted, except the NULL one. 

Note: Don't delete NULL this is current one.

Step5:  Execute below command

Delete from Keys where instalationID=<>

Step 6: Restart SSRS 

SQL Server Performance issue - With DB Compatibility upgrade from 120 to 150

Worked Solution:

We turned on the Legacy Cardinality Estimation on the database properties. 

If anyone has other solutions please comment.

SQL Server 2022 Services Failed To Come Online.

Error: Script level upgrade for database ‘master’ failed because upgrade step msdb110_upgrade.sql encountered error 926, state 1, severity 25

The above error will be present in the Error log and the solution will be to start the SQL Server either from /T902 or add this in strtup parameter to permently resolve this issue. 

This will bypass the upgrade script and starts the SQL Server. 

Reference:

https://blog.sqlauthority.com/2019/04/04/sql-server-script-level-upgrade-for-database-master-failed-because-upgrade-step-msdb110_upgrade-sql-encountered-error-8649-state-1-severity-17/