question

HatimAliJohar-5965 avatar image
0 Votes"
HatimAliJohar-5965 asked EchoDu-MSFT edited

SharePoint 2016 - Reporting Services using data in SQL Azure

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

office-sharepoint-server-administration
· 1
5 |1600 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.

Hi @HatimAliJohar-5965,the issue is more related with SharePoint, I added the related tag so that you may get more help from more expert.

1 Vote 1 ·

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered EchoDu-MSFT edited

@HatimAliJohar-5965,

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.

137637-image.png


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.



image.png (24.2 KiB)
· 4
5 |1600 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.

@HatimAliJohar-5965,

Do you have any progress on this issue?

Please remember to update this thread if you need further assistance.

0 Votes 0 ·

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.

0 Votes 0 ·
JoyZ avatar image JoyZ HatimJohar-3670 ·

@HatimAliJohar-5965,

The short answer is that if you use sharepoint server 2016, it will not be possible.

0 Votes 0 ·
Show more comments