Share via

SSRS as an Azure service

Michael Walsh 66 Reputation points
2023-01-03T21:22:41.623+00:00

Hello,

does Azure offer SSRS as a service?

Presently I have an azure VM running SQL 2019 and SQL Reporting services, SSRS. I would like to retire the VM and just have SSRS connecting to an Azure D/B.

Anyone know if this is "doable"?

Thanks.

Michael.

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.
3,066 questions
0 comments
Accepted answer
  1. Michael Taylor 60,331 Reputation points
    2023-01-03T21:33:27.227+00:00

    Microsoft released a blog article here on your options. Basically you need to look into Power BI if you want to get the equivalent SSRS reporting. But if you have a heavily customized investment in SSRS then just keep a VM running SSRS around and have your reporting DB in Azure. SSRS does not need to run on the same machine as the DB it retrieves data from. In fact this isn't even recommended.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Walsh 66 Reputation points
    2023-01-03T21:35:50.333+00:00

    Thanks very much for the info.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.