How to setup SSRS with an Azure SQL Server Database

Question

I have a SQL Server Database on Azure Cloud and I want to get a report server up and running using SSRS that would access the data on that database.

Does anyone have any experience with this scenario, or could provide me some guidance on how to go about this.

I'm reading about how SSRS would run on an Azure VM and that the SQL Server and it's respective Database(s) would be installed on that Azure VM. That's not my situation as I have existing SQL Database that exists outside of any VM I spin up.

Answer 1

You should host SSRS on Azure VM or on-premise. You can also choose to deploy SSRS to a virtual machine and use Azure SQL Database as your data source. You can refer to this article for more information.