SharePoint 2016 - Reporting Services using data in SQL Azure

Question

SharePoint 2016 - Reporting Services using data in SQL Azure

HatimAli Johar 46

Hi Team,

We wanted to know with SharePoint 2016 - Reporting Services, can we use with data stored in SQL Azure. If yes please share some reference articles.

Thank you,
Hatim

ZoeHui-MSFT 41,541 Reputation points

2021-10-05T07:43:28.717+00:00

Hi @HatimAli Johar ，the issue is more related with SharePoint, I added the related tag so that you may get more help from more expert.

1 answer

Your answer

ZoeHui-MSFT 41,541 Reputation points

2021-10-05T07:43:28.717+00:00

Hi @HatimAli Johar ，the issue is more related with SharePoint, I added the related tag so that you may get more help from more expert.

Answer 1

JoyZ 18,126

@HatimAli Johar ,

As far as I know, only SQL Server 2019 Reporting Services can now host a database catalog used for SQL Server Reporting Services (SSRS) in an Azure SQL Managed Instance (MI) that's hosted either in a VM or in your data center.

And SharePoint 2016 is not supported by SQL server 2019 Reporting services, so we cannot store data in SQL Azure with SharePoint 2016 - Reporting Services.

If an 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.

JoyZ 18,126 Reputation points

2021-10-08T06:08:38.63+00:00

@HatimAli Johar ,

Do you have any progress on this issue?

Please remember to update this thread if you need further assistance.
Hatim Johar 1 Reputation point

2021-10-08T06:26:42.313+00:00

Yes, what I learned so far with this thread is. We will need SSRS from SQL Server without SharePoint and there we should be able to consume data stored in SQL Azure. Then with SharePoint, we will just add links of SSRS Reports to make it accessible from SharePoint.
JoyZ 18,126 Reputation points

2021-10-11T01:38:39.507+00:00

@HatimAli Johar ,

The short answer is that if you use sharepoint server 2016, it will not be possible.
Echo Du_MSFT 17,341 Reputation points

2021-10-25T01:16:57.167+00:00

@HatimAli Johar If Julie's reply helps you, please remember to accept her reply as answer via the "Accept Answer" button, it will be beneficial to others in this forum who meet the same issue in the future. Thanks for your understanding and cooperation.

Share via

SharePoint 2016 - Reporting Services using data in SQL Azure

1 answer

Your answer