Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raysefo
Constraint Violating Yak Guru
260 Posts |
 Posted - 2013-05-23 : 04:50:03
|
| Hi,I have a web app which runs almost 3 years without getting this error. But last 3 days I am getting this error frequently:System.Data.SqlClient.SqlException (0x80131904): 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.)I checked my open SQL connections on the source code, they seem OK. By the way I am using SQL Server 2008 r2. When I run this query below:select * from sys.dm_exec_sessionsI get 143 records but they are NOT related with my web applicaitons. There are 5-6 other applications running on the web server. I wonder what may cause this error? Any ideas?Best Regards. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-05-23 : 12:04:27
|
| Is SQL on a cluster? I typically see this when I am connected to SQL and the instance fails over, and then I execute a query.-Chad |
 |
|
|
|
|
|
A transport-level error has occurred when sending