This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 57.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Can we configure Report Server Database and Temp Serve Database on Azure SQL Server where we can deploy reports on it (Azure SQL Database).
If not, then what is the reason? and is it possible in future?
What are its workaround?
SQL Server Reporting Services Installation Steps
How to setup SSRS with an Azure SQL Server Database
If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.
i have gone to both of the links. They have mention to use Azure SQL MI or SQL Sever (On-premise/Azure SQL VM) to configure SSRS.
My requirement is to Configure SSRS completely on Azure SQL Server.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
@Sarvesh Pandey To set up an SSRS instance, you should either use SQL Server on VM or SQL Managed instance.
You cannot use Azure SQL Database.
----------
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
ok I Got!
Can you please explain me why we shouldn't use Azure SQL DB.
I am confused on this.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 35%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
We cannot use Azure SQL DB to be used as Report Server DBs? is that not possible?
Also this document talks about the same: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-ver15
@Anmol Ganju @Sarvesh Pandey
A report server is required by SSRS to create databases for holding report server metadata and objects. These databases can be created on an
Azure SQL Database is not a supported configuration for creating report server databases.
This should not be confused with data source for SSRS reports.
The link you have provided explains how you can connect to an Azure SQL database to fetch data for visualization on the report. There are no limitations on consuming data from an Azure SQL database.
I hope this clarifies.
Let me know if you have any further questions.
@KalyanChanumolu-MSFT thanks for the quick response.
Hi @KalyanChanumolu-MSFT
, do you have blogs saying Why SSRS reporting database cannot be configure on Azure SQL DB and can be configured on Azure SQL MI?
Hi @Sarvesh Pandey ,
Please also refer this for details.
Microsoft Azure SQL Database is a cloud-based, hosted relational database built on SQL Server technologies.
To include data from SQL Database in your report, you must have a dataset that is based on a report data source of type SQL Database.
This built-in data source type is based on the SQL Database data extension.
Use this data source type to connect to and retrieve data from SQL Database.
sql-azure-connection-type-ssrs
Regards，
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November
Hi @ZoeHui-MSFT , do you have blogs saying Why SSRS reporting database cannot be configure on Azure SQL DB and can be configured on Azure SQL MI?