Report Server on Azure SQL database

Sarvesh Pandey 141 Reputation points
2021-02-08T07:22:48.08+00:00

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?

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,818 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. SUNOJ KUMAR YELURU 13,956 Reputation points MVP
    2021-02-08T07:30:54.62+00:00

    HI @Sarvesh Pandey

    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.


  2. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-02-08T07:46:36.697+00:00

    @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.


  3. ZoeHui-MSFT 33,386 Reputation points
    2021-02-09T05:49:43.73+00:00

    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