Forum Discussion

nelson777's avatar
nelson777
Frequent Visitor
4 years ago

SQL Server Connects but don't refresh report

Hi there,    I have installed and built the gateway for an on-premises gateway using SQL Server and although the gateway connection is working I can't get my report refreshed.   I have checked a ...
Need Help
v-jinweili-msft's avatar
v-jinweili-msft
Microsoft Employee
4 years ago

Hi nelson777 ,

 

The reason of your issue is an existing connection was forcibly closed by the remote host. Based on the error information you provided, we recommend you to follow the following aspects to troubleshoot.

• To fix this issue, make sure that both the client and server involved in a connection are running Windows that have the leading zero fixes for TLS_DHE installed. It's recommended to install the updates since they enhance the conformance to TLS_DHE specifications.
• Is the firewall turned on in the server that installing SQL Server?

 

You can refer to this article.
We have found a similar thread for your reference.

 

Best Regards,
Jinwei Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.