none
SharePoint Migration 2012 - 2016 / How to deal with SSRS in SP integrated mode?

    Question

  • Hello,

    I'm planning to migrate my SharePoint 2013 farm with SSRS 2012 to a  SharePoint 2016 farm and SSRS 2016. SSRS is running in SharePoint integrated mode While migrating everything SharePoint is not an issue, I'm a bit lost on how to approach the SSRS upgrade. Do I e.g. need to start with SSRS 2012 in the 2016 farm and upgrade SSRS after the content migration?

    So, If anybody could point me in the right direction, provide me some links that would be great!

    Thanks and best regards,

    Sven


    Wednesday, January 03, 2018 2:18 PM

Answers

  • Well, I reinstalled the farm since it was a test farm and I needed to make some changes to it's architecture. And now SSRS works.

    Fascinating... 

    Still, thanks for your answers and your support Trevor

    • Marked as answer by SvenMar Friday, January 19, 2018 11:30 AM
    Thursday, January 18, 2018 4:18 PM

All replies

  • SharePoint 2016 only supports SSRS 2016. But the transition is easy:

    Backup your SSRS databases. Backup the encryption key (go to Manage Service Apps -> Your SSRS SA to back the key up).

    Restore the SSRS databases. Note that you cannot change the SSRS database names. Their schema has hard coded reference to these names. Install SSRS as you normally would. Create your SSRS SA on SharePoint 2016 using the same database name for the reporting database (e.g. "ReportServer"). Restore your encryption key in the SSRS SA.

    That's it.


    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Wednesday, January 03, 2018 3:26 PM
    Moderator
  • Hi,

    I'll test this today. Thanks for your help. By the way, love your book!

    Cya, Sven


    Thursday, January 11, 2018 1:57 PM
  • Ok, it basically worked, but if i want to actually use SSRS, I get errors. For Example, when I try to configure the SSRS Settings in the CA, I it tells me something went wrong an I get these entries in the ULS log:

    01/11/2018 16:18:07.26 w3wp.exe (0x4D74) 0x5E34 SharePoint Foundation Feature Infrastructure fs75 Medium Feature definition missing for Feature 'ReportServer' (Id: 'e8389ec7-70fd-4179-a1c4-6fcb4342d7a0'; CompatibilityLevel: '15') 997f3f9e-1808-b04f-01eb-5ff7a6214977
    01/11/2018 16:18:07.28 w3wp.exe (0x4D74) 0x5E34 SharePoint Foundation General 8e1f High Failed to find the XML file at location '16\Template\Features\ReportServer\feature.xml' 997f3f9e-1808-b04f-01eb-5ff7a6214977
    01/11/2018 16:18:07.28 w3wp.exe (0x4D74) 0x5E34 SharePoint Foundation Feature Infrastructure fs75 Medium Feature definition missing for Feature 'ReportServer' (Id: 'e8389ec7-70fd-4179-a1c4-6fcb4342d7a0'; CompatibilityLevel: '15') 997f3f9e-1808-b04f-01eb-5ff7a6214977

    And get-spfeature -identity ReportServer Produces this error:

    PS N:\> get-spfeature -identity ReportServer
    get-spfeature : Cannot find a Feature object with Path or Id: ReportServer in scope Local farm.
    At line:1 char:1
    + get-spfeature -identity ReportServer
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : InvalidData: (Microsoft.Share...mdletGetFeature:SPCmdletGetFeature) [Get-SPFeature], SPC
       mdletPipeBindException
        + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletGetFeature

    But when I  just do get-spfeature and then search for Report Server in the results, then I can see

    DisplayName                  Id                                                               CompatibilityLevel   Scope
    -----------                       --                                                               ------------------   -----

    ReportServer                   e8389ec7-70fd-4179-a1c4-6fcb4342d7a0     15

    Any Ideas?

    Thanks and best regads,

    Sven

    Thursday, January 11, 2018 5:38 PM
  • The features installed are:

    ReportServerItemSync           c769801e-2387-47ef-a810-2d292d4cb05d     15                   Web
    ReportServerStapling           6bcbccc3-ff47-47d3-9468-572bf2ab9657     15                   Farm

    IIRC ReportServer itself is a hidden feature; it only returns for Compat Version 14 anyhow, but it's still valid:

    Get-SPFeature -Identity 'E8389EC7-70FD-4179-A1C4-6FCB4342D7A0'

    Do you have the XML file C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\TEMPLATE\FEATURES\ReportServer\feature.xml?

    Have you tried updating to the current bits of SQL on your SSRS box - https://www.microsoft.com/en-us/download/details.aspx?id=54613. Also the SP1 addin on all of your SharePoint servers - https://www.microsoft.com/en-us/download/details.aspx?id=54268.


    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Friday, January 12, 2018 4:48 AM
    Moderator
  • Hi,

    SP1 was already installed on the DB and Application servers. First I had the SSRS Addin only installed on the web frontend servers. Now the Addin is installed on all SharePoint Servers. But still the same behavior.

    When I take a look at the errors for the migrated site, it tells me that the features that came with SSRS 2012 are missing. 

    • [MissingSetupFile] File [Features\ReportServer\ReportViewer.dwp] is referenced [3] times in the database [WSS_Content_cis-dib_443]
    • [MissingWebPart] WebPart class [125eff25-2854-c0b5-4924-b37c5e89803c] 
    • [MissingFeature] Database [WSS_Content_cistestweb_443] has reference(s) to a missing feature: Name = [Report Server File Sync], Id = [c769801e-2387-47ef-a810-2d292d4cb05d], , 

    I don't know if there's any connection.

    BR,

    Sven


    • Edited by SvenMar Saturday, January 13, 2018 12:23 PM
    Saturday, January 13, 2018 12:07 PM
  • That might be fine. Do you have the SSRS Content Types/ECB menu actions on SSRS items?

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    • Marked as answer by SvenMar Friday, January 19, 2018 11:30 AM
    • Unmarked as answer by SvenMar Friday, January 19, 2018 11:31 AM
    Saturday, January 13, 2018 4:34 PM
    Moderator
  • Hello,

    you mean items "Edit Datasource Definition" or "Edit Report in Re port Builder?" Those are available bit if I try to use then, SharePoint throws an error.

    Thanks and best regards,

    Sven

    Monday, January 15, 2018 2:20 PM
  • Well, I reinstalled the farm since it was a test farm and I needed to make some changes to it's architecture. And now SSRS works.

    Fascinating... 

    Still, thanks for your answers and your support Trevor

    • Marked as answer by SvenMar Friday, January 19, 2018 11:30 AM
    Thursday, January 18, 2018 4:18 PM