Is SSRS supported with Azure database?

Question

We are planing to move our on premise database to Azure DB. We have SSRS reports as well. Is there any solution with Azure database for SSRS?

Answer 1

Unfortunately SSRS is not supported on Azure SQL Database. If you need SSRS it makes more sense to use a SQL VM on Azure or a SQL Server instance on-premises.

In this URL you will find deployment strategies for SSRS on Azure SQL VM.

You can deploy SSRS to a VM and use Azure SQL Database as the data source, but maybe is cheaper to have your databases on the same SQL VM.

Once you deploy the VM containing SSRS, you can then connect SSRS to an Azure SQL DB. This article discusses connecting Azure SQL Database to SSRS.

If you want to vote for SSRS to be offered as PaaS service please vote here. However, here Microsoft states is not planning to add SSRS to Azure SQL Database in the future.