none
SSRS 2016 - Web Portal Issue RRS feed

  • Question

  • Hi,

    I've been experiencing issues deploying to, and accessing the web portal for SSRS 2016.

    I've seen this has been an issue for others, but I haven't had any luck getting it to work using their advice.

    I have full local admin rights and have tried using multiple browers running in admin mode.

    The following msg keeps appearing:

    The service is not available.

    The report server has encountered a configuration error.

    Any help would be greatly appreciated as I've been running around in circles with this.

    Thanks,

    Todd

    Wednesday, June 15, 2016 3:56 AM

Answers

  • Try domain account or managed service account instead of "Virtual Service Account".

    Also refer this link https://support.microsoft.com/en-us/kb/842423


    Regards, RSingh

    • Marked as answer by Todd Honey Thursday, June 16, 2016 8:39 AM
    Wednesday, June 15, 2016 7:06 AM
  • The issue is now resolved. I reinstalled SQL Server Express again, then configured the Report Server Service Account to match my own domain account. A little weird as I had previously tried this but perhaps something was wrong with the install.

    Cheers,

    Todd

    • Marked as answer by Todd Honey Thursday, June 16, 2016 8:40 AM
    Thursday, June 16, 2016 8:40 AM

All replies

  • Is it the SSRS services and configuration set properly in the Server ?

    Are you able to open the below links? Assuming that the http is not SSL.

    http://locahost/ReportManager

    http://localhost/Reports


    Regards, RSingh

    Wednesday, June 15, 2016 4:42 AM
  • Hi Rajen,

    Config in Reporting Services Configuration Manager appears to be correct.

    When I enter the following links:

    1. http://localhost/Reports_SQLEXPRESS/

    This appears to open with the new SSRS 2016 web interface but only displays message:

    The service is not available.

    The report server has encountered a configuration error.

    2. http://localhost/ReportServer_SQLEXPRESS/

    This link displays:


    • The report server has encountered a configuration error.  (rsServerConfigurationError)

    I've also gathered the error in report server log:

    library!ReportServer_0-1!2f80!06/15/2016-12:59:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    Regards,

    Todd

    Wednesday, June 15, 2016 5:25 AM
  • Are you using SQL Server Express Edition ??

    Regards, RSingh

    Wednesday, June 15, 2016 5:47 AM
  • Yes SQL Server Express Advanced.

    Report server mode: Native

    Regards, Todd

    Wednesday, June 15, 2016 5:49 AM
  • "Service Account does not have rights to check domain user's SID"

    What is the service account that is used for SSRS?

    Below link may be helpful,

    http://serverfault.com/questions/694580/service-account-doesnt-have-rights-to-check-domain-user-sids-ssrs


    Regards, RSingh

    Wednesday, June 15, 2016 5:53 AM
  • The service account is "Virtual Service Account"

    I've read the link but not sure how that could be applied here.

    Regards, Todd

    Wednesday, June 15, 2016 6:17 AM
  • Try domain account or managed service account instead of "Virtual Service Account".

    Also refer this link https://support.microsoft.com/en-us/kb/842423


    Regards, RSingh

    • Marked as answer by Todd Honey Thursday, June 16, 2016 8:39 AM
    Wednesday, June 15, 2016 7:06 AM
  • Hi Todd, dev team is trying to track down some more information on this issue. Would you be able to get in contact at rhys@microsoft?
    Wednesday, June 15, 2016 12:42 PM
  • Hi Rhys,

    Thanks for getting in contact. I've sent you an email.

    Cheers, Todd

    Thursday, June 16, 2016 1:56 AM
  • The issue is now resolved. I reinstalled SQL Server Express again, then configured the Report Server Service Account to match my own domain account. A little weird as I had previously tried this but perhaps something was wrong with the install.

    Cheers,

    Todd

    • Marked as answer by Todd Honey Thursday, June 16, 2016 8:40 AM
    Thursday, June 16, 2016 8:40 AM