SSRS Report Server Connection refused

Question

Hello,

i have trouble with SSRS, when i try to connect on the local Server via http://localhost/reports or http://localhost/reportserver the connection is refused. On the machine there are SQL Server2022 and SSRS 2022 installed. I checked the services and the local firewall rules for http and https, everything seems fine.

Furthermore i tried to connect on 443 with a certificate but it is still refused.

Test-Netconnection -Computername localhost -Port 80 ends up with a TCPTestSucceeded false.

Moreover i checked the URLs registered in netsh. Everything seems fine there too.

Also i checked the logfiles, there is a Entry with ReportingServicesWMI!8160!7272!2025/01/23-16:27:55!N27User!I!Attempt to reconnect to RPC server failed with hr = 0x800706b3, but i don't know if this is my problem, because i didn't find anything when i google this error.

Do you have any idea what i can do to resolve this error?

Answer 1

It sounds like you've already done a lot of troubleshooting! Here are a few additional steps you can try to resolve the connection issue with SSRS:

1. Check SSRS Configuration:
   • Ensure that the SSRS service is running. You can verify this in the SQL Server Reporting Services Configuration Manager.
   • Verify that the URLs for the Report Server and Report Manager are correctly configured in the SSRS Configuration Manager.
2. Firewall and Port Settings:
   • Double-check that the firewall rules allow traffic on ports 80 (HTTP) and 443 (HTTPS).
   • Ensure that no other applications are using these ports.
3. Service Account Permissions:
   • Ensure that the service account running SSRS has the necessary permissions to access the Report Server database and other required resources.
4. Check for Binding Issues:
   • Use the netsh command to check for any binding issues. Ensure that the URLs are correctly registered:

          netsh http show urlacl
     

5. Review Log Files:
   • Check the SSRS log files for any additional error messages that might provide more insight. The log files are typically located at:

          C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles
     

6. RPC Server Error (0x800706b3):
   • This error indicates an issue with the RPC server. Ensure that the RPC service is running on your server. You can check this in the Services management console (services.msc).
7. Reinstall SSRS:
   • If all else fails, consider reinstalling SSRS to ensure that all configurations are correctly set up.

These steps should help you identify and resolve the issue. Let me know if you need further assistance!

Jonathan