SharePoint 2016 - Reporting Services using data in SQL Azure

HatimAli Johar 46 Reputation points
2021-10-04T16:38:32.883+00:00

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

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,897 questions
{count} votes

1 answer

Sort by: Most helpful
  1. JoyZ 18,056 Reputation points
    2021-10-05T08:36:47.727+00:00

    @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.

    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.