SSRS 2016 on Azure VM to SQL Managed Instance - Encryption Key issue

Question

Fellow DBA's

We have migrated a VM to Azure VM. That VM had/has SSRS 2016 on it. We have also migrated the SSRS dbs to SQL Managed Instance. All Went well until SSRS configuration.

Resteablishing db connection went perfect.

But when we restore the encryption keys. We get below message in the logs - cursor spins forever.

 Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Cannot get edition information from catalog server., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

One more thing, which might be the cause, the SSRS 2016 edition on the Azure VM is developer Edition - this is non prod. The SSRS dbs are on MI. I am curious if this is the cause of the Edition error message.

Any help would be appreciated.

Thx

mg

Answer 1

Hi @mark gordon

Based on my searches, SQL Managed Instance offers close to 100% compatibility with the latest SQL Server (Enterprise Edition) database engine. I also found examples of installing the developer edition on an Azure VM: https://www.mssqltips.com/sqlservertip/6620/install-ssrs-reportserver-databases-on-azure-sql-managed-instance/.

I don't know much about Azure SQL Managed Instance, but the version may be a reason. I found in the official documentation that Azure SQL Managed Instance support is mentioned in the new features of SSRS 2019: https://learn.microsoft.com/en-us/sql/reporting-services/what-s-new-in-sql-server-reporting-services-ssrs?view=sql-server-ver15#sql-server-2019-reporting-services. In some articles, it is also possible to host a report server database on Azure SQL Managed Instance using SSRS 2017.

You can refer to these links to view the details and steps to migrate the report server database of SSRS instance to Azure SQL Managed Instance:

Hosting SSRS databases in Azure SQL Managed Instance

Modernizing SSRS And A Step-by-Step Guide to Bringing ReportServer Databases to SQL Managed Instance

Best regards,

Aniya

Answer 2

Fellow DBA's

I did find out that this will not work. Using SSRS developer edition will not work with the ssrs dbs being on MI.