Unable to Connect to Remote Server
Symptom
When trying to run reports in web browser, the following error message appears:
Unable to connect to the remote server.
Subscriptions may also be affected by this error.
Causes
- The SQL Server Reporting Services service has stopped in your SQL server.
- In case of the recent SQL Server upgrade, the SQL Server suite could be corrupted.
- The SSRS instance evaluation license has expired.
Resolutions
In case the SQL Server Reporting Services service has stopped − enable the service and disable disable timeout for reports. Refer to the following articles for additional information:
- Learn how to enable the SQL Server Reporting Services service in Start and Stop the Report Server Service · Microsoft 🤝.
- Learn more on timeouts in Setting Time-out Values for Report and Shared Dataset Processing (SSRS) · Microsoft 🤝.
In case of the failed SQL Server upgrade, repair your SQL Server installation. Learn more in Repair a Failed SQL Server Installation · Microsoft 🤝.
For additional information on expired evaluation license in SSRS, refer to the following article: Error 503 − Reports and Subscriptions Not Working.