Licensing SQL Server 2016 Reporting Services - Sharepoint

Alexey Bulgakov 21 Reputation points

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?

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,784 questions
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,789 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,561 Reputation points

    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.

    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.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Matus Corny 6 Reputation points

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

    1 person found this answer helpful.
    0 comments No comments

  2. Olaf Helper 40,576 Reputation points

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

    0 comments No comments