question

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 asked ·

SSRS reports - cloud migration path

What is the best way to migrate SSRS reports to the cloud? The idea is that the reports are not a part of a distribution anymore. Instead, when users want to run reports from the existing Web application they get them from my company's cloud. So to the users it would be totally transparent except maybe new look. Am I heading right direction?

Thanks

sql-server-reporting-servicesazure-cloud-services
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@markgoldin-3750 Any update on the issue?

If the suggested response helped you resolve your issue, do click on "Mark as Answer" and "Up-Vote" for the answer that helped you for benefit of the community.

Thanks.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered ·

Hi,

Currently SSRS do not have cloud version, viz, there is no SaaS for SSRS on Azure.
You could only use a VM on Azure to host the SSRS server.

Other choice is you could consider Power BI service. They could offer this kind of possibility but this is another software, that we may need to take little time to adapt : What is the Power BI service?



Regards,
Lukas



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.



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

prmanhas-MSFT avatar image
1 Vote"
prmanhas-MSFT answered ·

@markgoldin-3750 You will need to host SSRS either on an Azure VM.

In this link deployment topologies for SSRS on Azure VM are discussed.

One method is to deploy SSRS to a VM and use Azure SQL Database as the data source.

Once you deploy the VM containing SSRS, you can then connect SSRS to an Azure SQL DB. This article discusses connecting Azure SQL Database to SSRS.

Hope it helps!!!

Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.