SQL Server Reporting Service (SSRS) on Azure SQL Database

2
votes

Azure SQL Database supports Full recovery model and we can't change the recovery model of Azure SQL Databases.

As mentioned here while making report server all application data is stored in reportserver and reportservertempdb.

According to the specific recommendations reportserver follows full recovery model and reportservertempdb follows simple recovery model.

So is it only the reason that reportservertempdb follows simple recovery model and that is not supported by Azure SQL database we can't configure SSRS on Azure SQL Database or there is something else too.

Please help me out with this with docs or links.

1
sql-serverazurereporting-servicesazure-sql-database
It's not very clear that what your problem is. Can you clarify it for us? - Leon Yue
Hi @shubhi jain, welcome to stack overflow, we are all glad to help you can response us. If my answer is helpful for you, plase accept it as answer( click on the check mark beside the answer to toggle it from greyed out to filled in.). This can be beneficial to other community members. If you have any other concerns, please feel free to let me know, thank you. - Leon Yue
thank you for the answer and it is helpful for me as it is exactly what I am looking for. Thank you so much :) - shubhi jain

1 Answers

2
votes

Azure SQL single database doesn't support SSRS. And Azure SQL database product team said they have no plan to add it.

You can continue configure the SSRS for Azure SQL managed instance or use if for SQL Server in VMs.

Ref this feedback: enter image description here

HTH.