connection error runninf SSRS report

Question

I am getting the following error running any report:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing

The thing is I am not even using SSRS Server. The report is running using ReportViewer in Local mode and processing takes place in ASP.NET app.

Thanks

Answer 1

Hi @mark goldin ，
I assume the reports you are trying to open are from a report server on another machine, not a local report. If it is not, please feel free to correct me.

To open a report on a remote report server, please verify the following:

1 ) You first must enable impersonation. To do this insert the following line into the web.config file:

<!-- Web.config file. -->    
<identity impersonate="true"/>  

Impersonation is disabled by default.

2 ) Make sure that the report server is configured for remote management, including firewall settings, etc. When the configuration is wrong, errors may occur. For more information, please see: Configure a Report Server for Remote Administration.

3 ) Ensure you have permission to remotely access the report server.

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.