Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transport error situation
Message
De
12/09/2013 08:54:37
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Transport error situation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01582978
Message ID:
01582978
Vues:
44
I have this message which appears on occasional basis:

"A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)"

The first two times we got it, it was in the middle of the night when a backup was in process eating up pretty much all the resources. For about a few minutes, this error came several times when we tried to access the Web site. On both occasions, it last for about 5 to 10 minutes. It is only during that timeframe that the error occured.

So, we were said this was probably because of the backup procedure and something they have to enhance in that direction.

Then, the error continued to happen but only on one specific transaction. It is only when administrative persons access a specific list to detect the state of the network and that fails on a very simple SQL. So, all the upcoming errors after that were isolated, occuring on individual basis, from time to time. So, I am wondering why such a simple SQL would cause this error. And, BTW, when I had it last night, it was on a brand new network on a brand new facility on a brand new equipment. So, it is not the equipment but maybe a bad setting they would have applied on both locations. So, I thought maybe I have corrupted data that SQL command is trying to pull out. Can it be? Or, can this be related to a setting?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Répondre
Fil
Voir

Click here to load this message in the networking platform