"An existing connection was forcibly closed by the remote host" on ASP.NET website

When users try to access reports on our webiste they receive that error above. Those reports are located on another SQL server.

I don't have a lot of knowledge about web developing, database, or programing. I appreciate your assistance.
I've attached more of what the error says.

Thank you.
Untitled-picture.png
CCS-ITNetwork and Computer Systems AdministratorAsked:
Who is Participating?
 
CCS-ITConnect With a Mentor Network and Computer Systems AdministratorAuthor Commented:
We went a different route.

1. We found that the cert in the database had experied. We renewed it
2. Then we had to update the cert in the ssrs Reporting Services Configuration Manager...we experienced some problems here. Long story short make sure the cert is correct.

Thank you for all who commented and replied.
0
 
funwithdotnetCommented:
How long does it take to generate the report? I'm not sure, however it may be that the query execution time exceeds the response timeout.
0
 
Pawan KumarDatabase ExpertCommented:
Check how much time the query is taking? If it is taking more time then ask your SQL guy to fix it.
0
 
CCS-ITNetwork and Computer Systems AdministratorAuthor Commented:
Others didn't point to the issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.