Share via

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?

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,878 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,900 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    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.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  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

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 43,246 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."

    0 comments