SSRS on Azure SQL Database Why its not supported?

2
votes

I came across one issue that I cannot create SSRS databases on Azure SQL Database, netiher I can use the migrated databases of report server in the SSRS Config manager, can anyone explain why is this a limitation and something like Managed Instance or Azure SQL VM is needed in this case?

Is there no other way of configuring Azure SQL Database with SSRS?

2
azurereporting-servicesazure-sql-database
did this stackoverflow.com/questions/29149308/…, can help you ? - mehdim2
Azure SQL offerings have changed dramatically since that question was asked almost 6 years ago. The branding of the products have changed also. - CigarDoug
Hi @The Man, If my answer is helpful for you, hope you can accept it as answer. This can be beneficial to other community members. Thank you. - Leon Yue
Hi @The Man, can you see my answer? do you have any other concerns? - Leon Yue

2 Answers

1
votes

Azure SQL database didn't explain why SSRS is not supported in Azure SQL database.

I think the reason the that Azure SQL database is PAAS and different between IAAS: Azure MI and SQL server in VMS: enter image description here

And for now, there is no way to configure SSRS for Azure SQL database. SQL database product team confirmed this. Ref this feedback:

  • "Thanks for your feedback here. You can do SSRS today in an Azure VM. I’m closing this as we have no plans in SQL DB to significantly grow it’s scope to SSRS."

If you still want to SSRS, you need to choose Azure SQL managed instance or SQL Server in VMs.

HTH.

enter image description here

0
votes

I think that you can pick a Azure Virtual Machine and then get things done by yourself, from scratch.

Or you can create RDLC and run them inside a web application, using Azure Database as data source.