SQL Server Reporting Service (SSRS) on Azure SQL Database

Shubhi Jain 6 Reputation points
2021-03-03T06:19:13.883+00:00

Azure SQL Database supports Full recovery model and we can't change the recovery model of Azure SQL Databases. As mentioned here https://feedback.azure.com/forums/217321-sql-database/suggestions/36400585-allow-recovery-model-to-be-changed-to-simple-in-az while making report server all application data is stored in reportserver and reportservertempdb. According to the specific recommendations reportserver follows full recovery model and reportservertempdb follows simple recovery model. https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/backup-and-restore-operations-for-reporting-services?redirectedfrom=MSDN&view=sql-server-ver15#backing-up-the-report-server-databases So is it only the reason that reportservertempdb follows simple recovery model and that is not supported by Azure SQL database we can't configure SSRS on Azure SQL Database or there is something else too. Please help me out with this with docs or links.

Azure SQL Database
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,576 Reputation points
    2021-03-03T06:44:25.44+00:00

    Azure SQL DB can't be used as backend for SSRS reports.

    See the similar question here - https://learn.microsoft.com/en-us/answers/questions/293464/can-we-perform-rdl-on-azure-sql-database.html?childToView=294625#answer-294625

    Similar answers to same question here - https://stackoverflow.com/questions/66451714/sql-server-reporting-service-ssrs-on-azure-sql-database

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.
    0 comments
  2. ZoeHui-MSFT 32,821 Reputation points
    2021-03-03T08:49:20.727+00:00

    Hi @Shubhi Jain ,

    To configure SSRS, we'll need to choose the report database.

    You can create the native mode report server database in the following ways:

    Automatic. Use the SQL Server setup wizard if you choose the default configuration option for installation. In the SQL Server Installation Wizard, this option is Install and configure on the Report Server Installation Options page. If you choose the Install only option, you must use SQL Server Report Server Configuration Manager to create the database.

    Manual. Use SQL Server Reporting Services Configuration Manager. Create the report server database manually if you use a remote SQL Server Database Engine to host the database. For more information, see Create a Native Mode Report Server Database.

    In the official documentation, there is also no choice for Azure SQL DB.

    ssrs-report-server-create-a-report-server-database

    ssrs-report-server-create-a-native-mode-report-server-database

    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

    1 person found this answer helpful.