CODEWITHSUNDEEP
.netsql
Simon Dugré
Simon Dugré

Reputation: 18916

A Transport-level error has occured when sending the request to the Server

Do anyone have a REAL and CLEAR way to solve this problem and an explaination of why it happens? Because, every thread i've read on how to solve this issue where not "politicaly correct". I mean, i saw things like "Restart machine, etc" but I get this error on a hosted dedicated server and I can't restart it like that.

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Thanks a lot and again, sorry for my english, i'm from Quebec.

Upvotes: 1

Views: 3536

Answers (2)

Hans Passant
Hans Passant

Reputation: 941873

You are looking for the problem at the wrong end of the wire. Pay a visit to the dba, bring gifts, work out a way to get notified about server reboots.

Upvotes: 3

Cade Roux
Cade Roux

Reputation: 89701

This can happen for a number of reasons, but like the error message says, this is at the transport level of the connection to the SQL Server.

Is your client/web server and SQL Server running on the same machine? This will be very rare in that case, since the network between them is static.

Is your connection to the server stable? Are you connecting over a WAN? Is the server subject to maintenance windows? Are there any firewall issues?

Upvotes: 2

Related Questions