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

views:

answers:

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.

+2 A:

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?

Cade Roux 2010-07-19 13:02:46

Wow loll. My head programmer is in Vacation now and thats why I'm in charge of that problem. But I don't know much about everyting you ask me to. All I can tell you is that I know that both have seperated server. But, can you tell me things I could try instead of thing i should know? Thanks !!!

Simon 2010-07-19 13:12:20

It is really difficult to give you answer better than this. We only know that you get connection error. @Cade Roux is absolutely right that there are more than one reasons of this.

Muhammad Kashif Nadeem 2010-07-19 13:29:15

@Simon we need to know a lot more. Are you saying all operation besides SELECT are failing? How are you connecting to the server? When you see this error, are you seeing it in a web page, in a client application or in SQL Server Management Studio?

Cade Roux 2010-07-19 13:31:53

SELECT works fine. INSERT, UPDATE and DELETE fails on a .NET application coded. We've getting a yellow page error raised by our web application. But sorry @Cade Roux, I woudn't say that your answer were not good, absolutly not. I know it's good. But, I mean that i'm not good enough in SQL and I must try something to solve it. Thanks

Simon 2010-07-19 13:42:08

@Simon I think it will just have to wait until someone gets back from vacation who knows how your application is architected.

Cade Roux 2010-07-19 15:17:51

So you are selcting from the same .net application? or are you selecting from the query window? Have you tried an insert from the query window and not the application? If that works then the problem may be in your .net connection.

HLGEM 2010-07-19 18:11:21

Well, now we've notice that the error getting less often than yesterday but it now also fails on selects query. So, all query type now get randomly the error. We've getting the error only from our web application. I've tried querying with SQL Management Studio and it works fine (With the same User/password informations)

Simon 2010-07-19 19:25:07

+1 A:

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.

Hans Passant 2010-07-19 14:13:36

You mean what? It could be because the server had reboot? There's currently missing a lot of people everywhere because of vacation...

Simon 2010-07-19 14:31:08

Server error. Not our problem. They finaly solve it. They needed a level 3 to solve it...

Simon 2010-07-20 20:33:34

I'm 17034 at this site. They count down though.

Hans Passant 2010-07-20 20:42:35

No, I mean a level 3 technician where the DB is :OP.

Simon 2010-07-20 20:47:12

Lol, even the tech tought it was solve but the problem comes back. I'll post here the solution once we know it.

Simon 2010-07-22 14:42:19

ansaurus

tags:

views:

answers:

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

related questions