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 wh开发者_如何学Pythony 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.

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.

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?