CODEWITHSUNDEEP
azureazure-sql-databaseazure-sql-reporting
PeonProgrammer
PeonProgrammer

Reputation: 1535

How to setup SSRS with an Azure SQL Server Database

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,

Upvotes: 33

Views: 74859

Answers (8)

Dig Agarwal
Dig Agarwal

Reputation: 111

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.

Upvotes: 5

Davison Nze
Davison Nze

Reputation: 1

Actually you do not to have your Azure SQL Database on the Azure VM. All Specify your connection string to point to your Azure SQL Database

Upvotes: 0

Aaron C
Aaron C

Reputation: 365

Power BI service (premium), now allows you to upload SSRS files, that can connect to the Azure DB. https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available/

Upvotes: 0

user3582680
user3582680

Reputation: 11

You can set up a Azure VM with SQL Server, start up the SSRS Reporting Configuration Manager. Go to SQL Server Management studio on your VM and create a linked server to your existing SQL Database. Create your queries in the VM database to reference the linked server's data. Then create your reports using the database on the VM, but those queries will be pulling the data from your non-VM database.

Upvotes: 1

Joseph Idziorek
Joseph Idziorek

Reputation: 5071

SSRS does not support Azure SQL DB for its Catalog and Temp DBs. This is a known issue. You have use to SQL Server (on-prem or Azure VM). You can create and run reports that consume date from Azure SQL DB though.

Upvotes: -1

elfisher
elfisher

Reputation: 1230

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!

Upvotes: 38

Maxim Alexeyev
Maxim Alexeyev

Reputation: 1031

Unfortunately, SSRS not supported by Azure Sql Server.

Upvotes: 0

Luis Vargas
Luis Vargas

Reputation: 40

That's correct, you'll need to migrate your database to a SQL Server running in an Azure VM. You can use the Azure Export Service (https://msdn.microsoft.com/en-us/library/f6899710-634e-425a-969d-8db1267e9471#ExportDB) to export your Azure Database into a dacpac. You can then import the dacpac to the SQL Server VM.

Upvotes: 1

Related Questions