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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
@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.
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