Few days back, one of our customer reported that his SQL Server 2019 reports were not accessible. We had a look at SQL Server Reporting Services logs. We observed below error messages in log:
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\RSManagement_2021_10_XX_XX_XX_XX.txt
2021-10-06 09:43:44.6709|INFO|1|SKU: SQL Server Evaluation
2021-10-06 09:43:44.6709|INFO|1|Installation has expired.
2021-10-06 09:43:44.6709|INFO|1|Logger shutting downWe checked edition for database engine as well as reporting service. We were not surprised to know that it was evaluation edition on both. By mistake, DBA did setup of evaluation edition instead of standard edition. Anyways, he had already left the organization.
Above logs clearly directed to upgrade license to standard or enterprise. DBA at customer end did edition upgrade using setup but license got upgraded only for database engine. Reporting Services configuration manager was still showing evaluation edition.
It is very important to note that in the past SSRS was an integral part of the SQL Server installation process. Since 2017, Report Services is a separate, stand-alone installation process. So the edition upgrade need to be done separately for SSRS 2017/2019.
Refer below :
We can simply do below :
1. Go to Control Panel ->Programs -> Programs & Features.
2. Select uninstall and change a program.
3. Select SQL Server Reporting Services .
4. Right Click and Click on Uninstall/Change.
5. We got below screen to enter license for required edition upgrade.
I hope this will help you in case similar issue is observed.
Happy Learning.