3

i have single server (sql 2016 +all SharePoint 2016 role) when i click on a report to run (uploaded rdl file) SharePoint give me error There are no addresses available for this application

error

and in Manage Reporting Services Application when i click on system setting i got The remote server returned an error: (503) Server Unavailable.

reconfiguration SSRS application dos not help

please help me

Improve this question

1 Answer 1

Reset to default
0

This error is telling two things.

  1. Check from the Central admin that "SQL Server Reporting Services Service" is started. Central Admin > Application Management > Manage Services on Server
  2. Also check IIS and make sure all the related App Pools are started. 2nd error 503 means App pool stop.

Also check this document to make sure you did not miss any step: https://docs.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/reporting-services-report-server-sharepoint-mode

Improve this answer
7
  • tanks for answer i check iis, all app pools are started include web service root and system SQL Server Reporting Services Service was stopped i use Install-SPRSService to start service and i did it but the problem not resolve
    – Hussein Ardakani
    Commented Oct 31, 2017 at 14:54
  • check if App pool stoped again? also check the event log for the more clue
    – Waqas Sarwar MVP ♦
    Commented Oct 31, 2017 at 15:03
  • app pool started but i use Set-SPServer SERVERNAME -Role Custom command, now i can start manually SSRS service in Services on Server (before that start action not available) but i got error Value cannot be null. Parameter name: name
    – Hussein Ardakani
    Commented Oct 31, 2017 at 15:11
  • where you get the value cannot be null?
    – Waqas Sarwar MVP ♦
    Commented Oct 31, 2017 at 15:23
  • when i try start "SQL Server Reporting Services Service" in Services on Server
    – Hussein Ardakani
    Commented Oct 31, 2017 at 15:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.