SSRS URL gives a 503 error even though the service is running - The process cannot access the file because it is being used by another process
Upon browsing to the SSRS URL (ex: https://xxxxx.tylertown.gov/ReportServer or https://xxxxx.tylertown.gov/Reports) you receive an HTTP 503 error. The SQL Server Reporting Services service is running and restarting it does not make any difference to the error.
Event Viewer on the SSRS server has various errors such as:
Unable to bind to the underlying transport for [::]:8082. The IP Listen-Only list may contain a reference to an interface which may not exist on this machine. Â The data field contains the error number.
SSRS logs located at C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\SQLDmpr0091.log show errors such as:
2024-08-16 11:17:22.0307|INFO|1|CFG : listenerUrl = [http://+:8082/] (env)
2024-08-16 11:17:22.0307|INFO|1|CFG : rsConfigFilePath = [..\ReportServer\rsreportserver.config] (env)
2024-08-16 11:17:22.0463|INFO|1|SKU: SQL Server Developer
2024-08-16 11:17:22.1714|ERROR|1|Unhandled exception in Appdomain System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: The process cannot access the file because it is being used by another process
SSRS
Reports
ReportServer
SQL Server Reporting Services
SSRS cannot access the files because the port is being used by another process
On the SSRS server, open Services
Stop the SQL Server Reporting Services service (right click > Stop)
Find what is using the portÂ
Open an elevated Command Prompt window (right click > Run as Administrator)
Run the following. Replace xxxx with the port listed in the errors
netstat -ano -p TCP | find /I "listening" | find /I "xxxx"
netstat -ano -p TCP | find /I "listening" | find /I "8082"
The last column will provide the PID (Process ID)
Run the following. Replace xxxx with the PID returned in the previous step
tasklist /fi "PID eq xxxx"
tasklist /fi "PID eq 2712"
In Services, locate the conflicting service and stop it (Right click > Stop)Â
Start the SQL Server Reporting Services service (right click > Start)
Start the conflicting service (Right click > Start)
Chang startup type of the conflicting service to Automatic (Delayed Start)
Right click > Properties
Startup type select Automatic (Delayed Start)
Click OK
Reload the SSRS URL