locked
SQL Reporting Services availability in Azure PaaS RRS feed

  • Question

  • Hi,

    Is SQL Reporting Services (SSRS) available in Azure PaaS? If yes, how to enable this?

    I will look forward for your reply at the earliest as I need to make decision on this topic in my project.

    Regards.

    Kaviraju, Sr. Solution Architect

    BOSCH

    Tuesday, May 1, 2018 2:43 AM

Answers

  • Hello,

    The only option you have is moving to IaaS and create an Azure VM with SSRS. SSRS does not exist as PaaS or as part of the features Azure SQL Database offers.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com




    Tuesday, May 1, 2018 4:01 AM
  • Azure offers two options to create SQL Server database - PaaS and IaaS. PaaS offering is called Azure SQL Database and is a subset of an actual on-premise SQL server. The advantage is that it is managed by Microsoft, but, it doesn't offers SSRS. IaaS offering refers to setting up a full fledge SQL server on an Azure VM, This way, it supports all the feature set of on premise SQL Server including SSRS. You can either setup an Azure VM with SQL Server & SSRS or you could use PaaS offering as the database and use IaaS for SSRS alone. Check out this link for more details - https://docs.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-2017

    Hope it helps!


    - Vaibhav Gujral

    • Proposed as answer by Vaibhav Gujral Tuesday, May 1, 2018 4:14 AM
    • Marked as answer by Kaviraju Tuesday, May 1, 2018 5:54 AM
    Tuesday, May 1, 2018 4:14 AM

All replies

  • Hello,

    The only option you have is moving to IaaS and create an Azure VM with SSRS. SSRS does not exist as PaaS or as part of the features Azure SQL Database offers.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com




    Tuesday, May 1, 2018 4:01 AM
  • Azure offers two options to create SQL Server database - PaaS and IaaS. PaaS offering is called Azure SQL Database and is a subset of an actual on-premise SQL server. The advantage is that it is managed by Microsoft, but, it doesn't offers SSRS. IaaS offering refers to setting up a full fledge SQL server on an Azure VM, This way, it supports all the feature set of on premise SQL Server including SSRS. You can either setup an Azure VM with SQL Server & SSRS or you could use PaaS offering as the database and use IaaS for SSRS alone. Check out this link for more details - https://docs.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-2017

    Hope it helps!


    - Vaibhav Gujral

    • Proposed as answer by Vaibhav Gujral Tuesday, May 1, 2018 4:14 AM
    • Marked as answer by Kaviraju Tuesday, May 1, 2018 5:54 AM
    Tuesday, May 1, 2018 4:14 AM
  • Understood and thanks.!

    Kaviraju

    Tuesday, May 1, 2018 5:55 AM
  • Understood and thanks.!

    Kaviraju

    Tuesday, May 1, 2018 5:55 AM