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 runnning using SSRS that would accesses 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 a 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.

Thanks,

Answer 1

You will need to host SSRS either on an Azure VM or on premise.

In this link deployment topologies for SSRS on Azure VM are discussed.

One strategy is to deploy SSRS to a VM and use Azure SQL Database as the data source.

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

Hope this helps!

Answer 2

Another approach to SSRS support for SQL Azure is SQL SSRS containers. Windocks provides an automated approach that delivers configured SSRS containers for SQL Azure source databases. The advantage of containers in this case includes updating images, and greater scalability.