How to setup SSRS with an Azure SQL Server Database

azure azure-sql-database azure-sql-reporting
PeonProgrammer picture PeonProgrammer · Mar 19, 2015 · Viewed 58.6k times · Source

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

elfisher picture elfisher · Mar 20, 2015

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!

Related questions

Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried solutions using COALESCE and FOR …

Read More
Azure SQL Database "DTU percentage" metric

With the new Azure SQL Database tier structure, it seems important to monitor your database "DTU" usage to know whether to upgrade or downgrade to another tier. When reading Azure SQL Database Service Tiers and Performance Levels, it only talks …

Read More
How to re-create database for Entity Framework?

I have got into a bad state with my ASP.Net MVC 5 project, using Code-First Entity Framework. I don't care about losing data, I just want to be able to start fresh, recreate the database and start using Code-First migrations. …

Read More