14,503 questions
That isn't a timeout, it's an SSL / encrytion issue.
See Applications experience forcibly closed TLS connection errors when connecting SQL Servers in Windows
Error - existing connection was forcibly closed by the remote host
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 94%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Padmanabhan, Venkatesh
246
Reputation points
Hi. I am using a console .NET application which uses the SQL BCP queryout method to retrieve data from table and store in a delimited file. If the select query is taing a longer time, then i have observed this timeout. Are there any parameters which need to be added in BCP syntax to avoid this issue ?
Some times I am getting the below error : SQLState = 08001, NativeError = 10054
Error = [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: An existing connection was forcibly closed by the remote host.
SQLState = 08001, NativeError = 10054
Error = [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection
How to fix this ?
SQL Server | Other
{count} votes
-
Erland Sommarskog 122K Reputation points MVP Volunteer Moderator2021-09-21T21:51:41.747+00:00 Have you check the SQL Server errorlog for messages correlating with these errors?
This does sound like setting issue, but rather some network issue. Or a fatal accident inside SQL Server.
Sign in to comment
2 answers
Sort by: Most helpful
-
Olaf Helper 47,516 Reputation points2021-09-21T06:19:55.883+00:00 -
Padmanabhan, Venkatesh 246 Reputation points
2021-09-21T06:22:16.69+00:00 Hi. Thanks for the reply.
This error is not happening every time. There are some queries which are running fine and the data is moved to the delimited file. Only for few queries, I am seeing this error. If it is an encryption issue, won't all the queries fail ?
Sign in to comment -
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2021-09-21T07:03:26.463+00:00 What are the windows versions on both servers? Suggest you reading the MS document that Olaf mentioned. Please check if your environment is one situation of that.
By the way, please check if this blog could help you. Suggest you to try the suggestions in test environment.
> If it is an encryption issue, won't all the queries fail ?
No, you may get an error at random times.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.