CODEWITHSUNDEEP
pythonsql-serverdatabaseazuredatabase-administration
OGZ
OGZ

Reputation: 35

Azure SQL Server Bulk Insert TCP Provider Problem

I use SQL Server on Azure and I make a bulk insert with Python but I constantly get error. How can I solve the problem?

Error : TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host

Best, Thanks

Upvotes: 1

Views: 177

Answers (1)

Utkarsh Pal
Utkarsh Pal

Reputation: 4554

As per the Microsoft official document, this error message returned when the secure TLS handshake is negotiated between the client and the server by using TLS_DHE cipher suite.

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.

If you can't update the windows, a workaround is available here.

Upvotes: 0

Related Questions