none
Reporting Services 2017 RC1 - RPC Server is not listening RRS feed

  • Question

  • Hi,
    Im seeing issues with SSRS 2017 RC1. The configuration manager is extremely slow to load and move between tabs. I am also seeing an “RPC Server is not listening” error when trying to create a Report Server database on SQL 2017 RC1 & SQL 2016. I can connect to an existing SQL 2016 Report Server though.

    Ive tested this on 2 Windows Server 2012 R2 VMs in different environments/domains.

    Also, all of the above works perfectly with the SSRS 2017 March CTP, on the same servers too. Hope that helps.

    I also see a DLL error in the logs:
    RSPortal!reportserverwebapp!RSPortal.exe!1!07/20/2017-05:31:45:: e ERROR: Unhandled exception: System.IO.FileLoadException: Could not load file or assembly ‘Microsoft.SqlServer.MgdSqlDumper, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A)
    File name: ‘Microsoft.SqlServer.MgdSqlDumper, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ —> System.Security.SecurityException: Strong name validation failed. (Exception from HRESULT: 0x8013141A)
    The Zone of the assembly that failed was:
    MyComputer
    at Microsoft.ReportingServices.Diagnostics.Globals.InitServer(Boolean resetAllPerfCounters)
    at Microsoft.ReportingServices.Portal.WebHost.Program.Run()
    at Microsoft.ReportingServices.Portal.WebHost.Program.Main(String[] args)

    Thursday, July 20, 2017 11:40 AM

Answers

  • Thanks to the error details CPorteous provided, we were able to identify the issue and we've released a fix.

    To resolve the issue:

    1. Re-download SSRS 2017 RC: https://www.microsoft.com/en-us/download/details.aspx?id=55252.
    2. Run the installer and choose "Upgrade Reporting Services."
    3. Run Report Server Configuration Manager and you should be able to configure your report server.

    Group Program Manager | SQL Server Reporting Services


    Friday, July 21, 2017 10:16 PM

All replies

  • I'm getting the same error with Server 2016, SQL 2017 RC1 and Reporting Services 2017 RC1 and am unable to complete the SSRS configuration.  Also seeing the following Application Event log error:

    Application: RSManagement.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.Security.SecurityException

    Exception Info: System.IO.FileLoadException
       at Microsoft.BIServer.Configuration.SqlDumperAdapter.Microsoft.BIServer.Configuration.IDumperAdapter.Prepare()
       at Microsoft.BIServer.Configuration.Dumper..ctor(Microsoft.BIServer.HostingEnvironment.SimpleConfig, Microsoft.BIServer.Configuration.IDumperAdapter)
       at Microsoft.BIServer.Configuration.Dumper.Create(Microsoft.BIServer.HostingEnvironment.SimpleConfig, Microsoft.BIServer.Configuration.IDumperAdapter)
       at Microsoft.BIServer.Management.WebHost.Program.Main(System.String[])


    Thursday, July 20, 2017 5:50 PM
  • Hi CPorteous,

    In your scenario, it seems that this issue only occur on your current machine, it works well in your test machine, right?

    Based on my research, If you get the "RPC Server is not listening" error, please verify that the Report Server service is running. You also could refer to this post for help.

    In addition, whether you are configuring a Report Server for remote administration? If so, you could refer to Configure a Report Server for Remote Administration for details.

    By the way, when could not load file or assembly, you could try give the SQL Server Reporting Services(SSRS) service account the Read/Write permissions to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files to see whether it works or not.  Or you could try to use sn.exe to register for verification skipping("sn -Vr SomeAssembly"). You could refer to Solution to "Could not load file or assembly or one of its dependencies. Access is denied" for details.

    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, July 21, 2017 7:48 AM
    Moderator
  • Hi,

    I think the RPC Server unavailable is a symptom of the consistent crashing of RSManagement.exe.  The following application event log messages occur just starting the SQL Reporting Services service. 

    Log Name:      Application
    Source:        .NET Runtime
    Date:          7/21/2017 12:16:13 PM
    Event ID:      1026
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      VISOPSSQLvNext.dev.ads.deltek.com
    Description:
    Application: RSManagement.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.Security.SecurityException

    Exception Info: System.IO.FileLoadException
       at Microsoft.BIServer.Configuration.SqlDumperAdapter.Microsoft.BIServer.Configuration.IDumperAdapter.Prepare()
       at Microsoft.BIServer.Configuration.Dumper..ctor(Microsoft.BIServer.HostingEnvironment.SimpleConfig, Microsoft.BIServer.Configuration.IDumperAdapter)
       at Microsoft.BIServer.Configuration.Dumper.Create(Microsoft.BIServer.HostingEnvironment.SimpleConfig, Microsoft.BIServer.Configuration.IDumperAdapter)
       at Microsoft.BIServer.Management.WebHost.Program.Main(System.String[])


    Log Name:      Application
    Source:        Application Error
    Date:          7/21/2017 12:16:14 PM
    Event ID:      1000
    Task Category: (100)
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      VISOPSSQLvNext.dev.ads.deltek.com
    Description:
    Faulting application name: RSManagement.exe, version: 14.0.600.310, time stamp: 0x596c1fb2
    Faulting module name: KERNELBASE.dll, version: 10.0.14393.1378, time stamp: 0x594a146b
    Exception code: 0xe0434352
    Fault offset: 0x0000000000033c58
    Faulting process id: 0x1268
    Faulting application start time: 0x01d3023cabd6bced
    Faulting application path: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\Management\RSManagement.exe
    Faulting module path: C:\Windows\System32\KERNELBASE.dll
    Report Id: a5939723-d371-4589-a9f7-ea997f269e25
    Faulting package full name:
    Faulting package-relative application ID:

    I've tried the following command without any changes:

    sn.exe -Vr "C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\Management\Microsoft.SqlServer.MgdSqlDumper.dll"

    Friday, July 21, 2017 5:17 PM
  • Thanks to the error details CPorteous provided, we were able to identify the issue and we've released a fix.

    To resolve the issue:

    1. Re-download SSRS 2017 RC: https://www.microsoft.com/en-us/download/details.aspx?id=55252.
    2. Run the installer and choose "Upgrade Reporting Services."
    3. Run Report Server Configuration Manager and you should be able to configure your report server.

    Group Program Manager | SQL Server Reporting Services


    Friday, July 21, 2017 10:16 PM
  • Thank you Riccardo, this worked perfectly. Glad I could help

    Craig

    Saturday, July 22, 2017 9:12 AM
  • It is not working for me...

    Aquellos Que No Conocen El Dolor Jamas Conoceran La Verdadera Paz

    Wednesday, February 7, 2018 1:58 PM