Network error code 0x80090330 - existing connection was forcibly closed by the remote host

Pds 46

Hi,
We have on going issue within our one of the job running every few minutes but every day it's keep failing 2-3 times randomly, no specific timing.
Basically Client m/c running BCP job which trying contact target database sql server 2014.
We checked TLS and it's all same on both Client and server.
We also have updated ODBC drive 13.
When I am checking the Sql Server Error log, every time it shows following error on Server:

Error:
Network error code 0x80090330 occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 136 ms, enqueued 0 ms, network writes 0 ms, network reads 1 ms, establishing SSL 134 ms, network reads during SSL 98 ms, network writes during SSL 0 ms, secure calls during SSL 36 ms, enqueued during SSL 0 ms, negotiating SSPI 0 ms, network reads during SSPI 0 ms, network writes during SSPI 0 ms, secure calls during SSPI 0 ms, enqueued during SSPI 0 ms, validating login 0 ms, including user-defined login processing 0 ms. [CLIENT: 10.X.X.X)

When I check log where our job running, I see following error:

SQLState = 08001, NativeError = 10054
Error = [Microsoft][ODBC Driver 13 for SQL Server]SSL Provider: An existing connection was forcibly closed by the remote host.
SQLState = 08001, NativeError = 10054
Error = [Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection

Any idea what happening when job is failing?

Erland Sommarskog 100.9K Reputation points MVP

2021-03-13T10:31:25.53+00:00

Using the old Error Lookup utility, I see that error 0x80090330 supposedly means "The specified data could not be decrypted. "

I will need to confess that I am not sure what this implies. But generally, spurious errors like this one, are often a token to a problem in the network structure. Like a switch flipping a few bits or somesuch.
Pds 46 Reputation points

2021-03-14T14:47:35.08+00:00

Thank you Erland.
So what exactly you are suggesting and how?
Again, Network failure error is random.
Erland Sommarskog 100.9K Reputation points MVP

2021-03-14T20:18:45.813+00:00

I'm not suggesting much. I only wanted to provide the likely meaning of the error code.

You say that this is a job. But that is not an agent job? Does this only happen with BCP? Do any other connections to SQL Server run from this machine?
Pds 46 Reputation points

2021-03-16T14:06:17.833+00:00

Thanks Erland.
Mostly with the BCP job but we have couple T-Sql block that also failing but like BCP failure.
Pds 46 Reputation points

2021-03-16T14:07:33.227+00:00

Also it;s not a Agent job.
Erland Sommarskog 100.9K Reputation points MVP

2021-03-16T20:50:17.42+00:00

Mostly with the BCP job but we have couple T-Sql block that also failing but like BCP failure.

As I said, this sounds like a spurious problem in your network infrastructure. Can surely be difficult to track down.
Pds 46 Reputation points

2021-03-16T21:02:10.46+00:00

Thanks Erland.
I agreed that it will be difficult that's why trying get expert advice.
Tried different way troubleshooting but couldn't find right solution.

6 answers

pdsqsql 391 Reputation points

2021-04-16T22:32:16.917+00:00

Ok, Thank You for valuable info.
Please feel free to update me anything which can help me to try it out.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment