We have a web service long job running overnight that failed occasionally. The error message is An existing connection was for forcibly closed by the remote host.
This web service job runs about 4-5 hrs, and most of time it is successful. Only occasionally it fails. and once it fails, we restarted it, then it succeeded without any problem. The job is
a web service from web server that connect to SQL server database that process each product, so it has many network communication back and forth between web server and database server.
We have checked if the same time, any other jobs could affect, event log, SQL error log, backup, anti-virus, data, network, there are no errors, and we also used fqdn in the web.config, no help. and since it is intermittently fail, it is hard to troubleshoot.
Our system admin suggests to add IP and FQDN name in the host file of windows. But not very clear what to add...
So should I in the web server add in the host file: C:\Windows\System32\drivers\etc\hosts
for example my webserver name is TN_MyWebServer , IP is 10. xx. xx.001 and my database server is TN_MYDBServer1 IP is 10.xx.xx.004
Shall I just add the below line in the web server host ?
10.xx. xx.001 TN_MyWebServer
10.xx. xx.001 TN_MyWebServer. mydomain.com
Currently there is nothing in the host file other than commented out examples.
Do I also need to add database server IP and FQDN in the webserver host file?
Or do I need to add database server IP and FQDN in the database server host file?
Thanks!