Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS: HTTP Error 503. The service is unavailable

I have been wanting to deploy my SSRS reports to a Test server. However I found that on that server the SSRS service had stopped, and I had to change the setting so that it used a built in Network Service account. After doing that I found I could start the service. However when I key in the ReportService url in my browser, I get the above error message.

One problem that I had when I changed the settings to the Network Service account is that I got the error message:

"A connection could not be established with the information provide. Hit OK to change your connection settings. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: named Pipes Privider, error: 40 - Could not open a connection to SQL Server)"

Even so, this did not stop the service from starting. As a result of all this I still cannot deploy my reports. How do I fix this?

like image 940
arame3333 Avatar asked Dec 14 '11 15:12

arame3333


People also ask

What causes HTTP Error 503 the service is unavailable?

The HyperText Transfer Protocol (HTTP) 503 Service Unavailable server error response code indicates that the server is not ready to handle the request. Common causes are a server that is down for maintenance or that is overloaded.

How do I restart Reporting Services?

Click Start > Administrative Tools > Services to open the Services management console. Right-click the SQL Server Reporting Services ([InstanceName]) service, and then click Restart.

How do I open Reporting Services Configuration Manager?

In the Windows start menu, type reporting and in the Apps search results, click Report Server Configuration Manager. Click Start, then click Programs, then click Microsoft SQL Server, then click Configuration Tools, and then click Report Server Configuration Manager.


1 Answers

If you are running SSRS 2016, restart the SSRS services:

  1. SQL Server Reporting Services (MSSQLSERVER)
  2. SQL Server Reporting Services Web App (MSSQLSERVER)
like image 89
Tarzan Avatar answered Nov 03 '22 04:11

Tarzan