Reporting server ERROR : ther service is not available

Hania ABECHE 0 Reputation points
2023-01-18T13:10:56.12+00:00

we have Reporting server error when accessing the URL [http://reprtserverName:80/ReportServer and it displays the error " The service is not available " , and either the Reporting section in SCOM is empty . although the database is working correctly and all the services are running.

is there any solution ?

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

7 answers

Sort by: Most helpful
  1. diana.sl.carneiro@gmail.com 0 Reputation points
    2023-01-18T18:20:04.9266667+00:00

    Hi Hania,

    Just wanted to check in and make sure you're good with your Reporting Services Configuration Manager. Double-check that your Report Server URL and Web Service URL are set up correctly. If you're not sure, you can take a look directly on the server to check the results.

    Looks like it might be a network issue, but it's hard for me to say for sure without more info. Sorry about that! Let me know if there's anything else I can do to help.

    Best Regards

    0 comments No comments

  2. ZoeHui-MSFT 30,261 Reputation points
    2023-01-19T02:05:49.9933333+00:00

    Hi @Hania ABECHE

    Reporting server ERROR : the service is not available

    Is it the full error message? Could you please check the error log for more details?

    Could you please show us the Report Server Configuration Manager, make sure that you have apply the web service url and web portal url.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


  3. Hania ABECHE 0 Reputation points
    2023-01-19T08:40:43.9+00:00

    Hi @ZoeHui-MSFT , when i checked the logs this is what i found :

    " An error occurred when invoking the authorization extension ---> System.ServiceModel.FaultException'1[System.ServiceModel.ExceptionDetail] : Access is denied . ( Exception from HRESULT : 0x8007005 (E_ACCESSDENIED)) "

    even though the firewall is disabled .

    0 comments No comments

  4. ZoeHui-MSFT 30,261 Reputation points
    2023-01-19T09:22:58.9066667+00:00

    Hi @Hania ABECHE

    Access is denied . ( Exception from HRESULT : 0x8007005 (E_ACCESSDENIED)) "

    From the error message, this might be a permission issue.

    What account are you using to open the web server url?

    Please try to run the browser as admin to see if you could open ReportServer manager.

    Check: Grant user access to a report server

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  5. Hania ABECHE 0 Reputation points
    2023-01-19T09:48:35.38+00:00

    Hi @ZoeHui-MSFT we found also this log in SCOM too

    " An exception was thrown while processing GetUserRolesForOperationAndUser for session ID uuid:d9eb913b-a75d-454d-8bf1-2bb8bef92384;id=1085.
    Exception message: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
    Full Exception: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) "

    and for Reporting Server we use the Reporting Data Reader Account .

    0 comments No comments