Licensing SQL Server 2016 Reporting Services - Sharepoint

Alexey Bulgakov 21 Reputation points
2020-09-21T19:04:18.037+00:00

Hello! We have a Sharepoint 2016 Server Farm, with Database tier on SQL Server 2017.
Now we want to install SQL Server 2016 Reporting Services in Sharepoint mode (i.e. install Reporting Services - SharePoint to our Sharepoint Servers).

Do we need a separate SQL Server 2016 licenses for our SP servers in case we already have some additional SQL Server 2017 server licenses available?
Or maybe, we can re-use our available 2017 licenses for SQL Server 2016 SSRS?

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,365 questions
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.
2,124 questions
No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2020-09-22T01:36:05.103+00:00

    Hi @Alexey Bulgakov
    No, the SQL Server 2017 licenses is not sufficient for using SSRS 2016.
    For using SSRS 2016 SharePoint integrated mode, we need separated SQL 2016 licenses for it.
    Regards,
    Joy


    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.

    No comments

2 additional answers

Sort by: Most helpful
  1. Matus Corny 6 Reputation points
    2020-09-23T09:32:38.86+00:00

    Also, you need SharePoint Enterprise CAL to implement SSRS SharePoint Integrated Mode

    No comments

  2. Olaf Helper 25,901 Reputation points
    2020-09-22T07:56:10.547+00:00

    A SQL Server license is bound to the version; you can not install 2017 with a 2016 license.

    And: Beginning with version 2017 SSRS don't support any long the SharePoint-integration mode, see SQL Server Reporting Services features supported by editions: "Starting in SQL Server 2017 Reporting Services, integration with SharePoint is no longer available."

    No comments