.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Inconsistent Transport-level error, drivin' me nuts!

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :ASP.Net

While on my local machine, the site works as expected, on my remote shared host I intermittently get this error on random pages (both local and remote site are connected to the same remote sql server, with the same connectionstring in web.config).

I'm using ASP.NET 3.5 and SQL SERVER 2005

Thanks in advance for any help

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.)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): A transport-level error has occurred when sending the r

View Complete Post

More Related Resource Links

Transport Level Error

Hello,I have a ASP.NET 2.0 based web application. At a certain point, I restore a specific MS Sql Server Database from a previously saved backup. The restore works perfectly, however, when I try to access the application again I encounter this error:A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)If I just refresh the page, or in other words, I wait for a few moments and then access the web application, it works just fine. I am at a fix understanding as to what may be causing this. I have gone through couple of other posts in this forum and other material on the internet talking about Connection Pools and so on. At the end, I am still unable to resolve this issue? Should I stoop to a lower level and just add some sort of delay after the restore is done, so that the user will never (hopefully) encounter the above said hiccup, or is there a smarter way to deal with this?Also, I am using NetTiers template to access my MS Sql Server database.Any suggestions are welcome! Thanks!

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider


Hi all,

I use Asp.Net 2.0 and SQL server 2000 and I get the above error in my site.I went through the other posts and reply.It is said to clear the connection pools.So i need a clear view what that will do.When should i actually clear it.Will Clearing the pools introduce any other problem or is there any othere solution for this. Please help me in solving this.



ADO NET A transport-level error has occurred when sending the request to the server. (provider: TCP


When i fill my sql adapter      daAuthors.Fill(dsPubs, "MyTable")

sometime i get

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.) 

What can couse the trouble thanks

Query/Connection/Connect unavailable after "a transport-level error has occurred"


In SSMS for SQL Server 2008, when I leave a connection open overnight to a remote server, I occasionally get disconnected.  This is OK, and it's not the issue.  I know there are several reasons that can cause this, such as the remote server could have been rebooted.

The problem is that once this happens, under the Query menu item, in the Connection sub-item, the Connect item is greyed out -- so I can't try to reconnect in the same window.  I also have a Connect icon on the toolbar, and it is greyed out also.  This query window is now dead. 

If I open a new query window, I can connect with no problem, but I have to copy any temporary SQL code I was working with from the now-useless original query window, into the new one.

Why would the Connect item become permanently unavailable?  SQL 2005 didn't do this.  I have installed the latest CU on SQL Server client tools (SSMS says the client tools are at 10.0.4270.0).  Client is on Windows 7 Pro x64.

Thanks for any info.

A transport-level error has occurred when receiving results from the server.(provider:TCP Provider,e



I am using SQL Server 2005,

while trying to retrieve data from the database; I am getting the following error:

 A transport-level error has occurred when receiving results from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)

 But I am getting this error randomly.

 Can some one help me out?
 Waiting for your response


Web Part working fine on the top-level page but 'Not Safe' error on lower-level pages.


I have created a Web Part which reads and parses the SharePoint logs in order to display usage information of the page it resides on.  The Web Part works perfectly on the top page, reading and displaying the information desired.  However, once the Web Part is added to any page lower in the site heirarchy (sub-page) the same Web Part throws the following error:

Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.

Show Error Details
Hide Error Details

[UnsafeControlException: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.]
  at Microsoft.SharePoint.ApplicationRuntime.SafeControls.GetTypeFromGuid(Guid guid)
  at Microsoft.SharePoint.WebPartPages.SPWebPartManager.CreateWebPartsFromRowSetData(Boolean onlyInitializeClosedWebParts)

Of course the current version of the Web Part is in the SafeControls list on the web.config.

The Web Part was originally designed to return site activity only for the top default.aspx page and worked fine but started to fail in the manner described above once I added the following line of code to return a SPCo

Msg 15121, Level 16, State 10, XP_Cmdshell - A call to 'CreateProcessAsUser' failed with error cod

I have the XP_cmdshell issues for the past two days in SQL2005 SP2 environment. There is a domain account with sysadmin privilege. I have created a proxy account and gave the execute privilege for xp_cmdshell. If i try to run the following commmand EXEC master..xp_cmdshell 'dir *.txt' Msg 15121, Level 16, State 10, Procedure xp_cmdshell, Line 1 An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with error code: '1314'. But if i give sysadmin priv and then i try to execute. It worked. I cant give sysadmin priv so i m using a proxy account. Whether any one have solution for it.

Msg 8624, Level 16, State 13 - Internal SQL Server error.

Hi, I have a weird T-SQL 80 query full of nested subqueries full of aggregations tha thas been embedded in a view. if I do select * from the view I get: Server: Msg 8624, Level 16, State 13 Internal SQL Error.  If I run the same block of code from the query analyzer it runs fine. Also if I wrap exactly the same code in a SP it runs fine. I'm running this on a SQL Server 2000 Standard Edition SP4 8.00.2282. + I turned on the following Trace Flags: 3614, 9052, 9054, 9056, 9057, 9185, 9256. If I restore the same DB on a SQL Server 2005 and do the same select * it runs fine. So I'm getting the Error 8624 only on my SQL 2000 Standard edition  SP4 8.00.2282. Another thing I dont understand is also: why I can compile the view but if I try to visualize even the query plan I get the same error?!? Any suggestion will be appreciated. Thank you. Regards, Marco    

Transport level security with netTcpBinding

Does service and client need to be part of domain with netTcpBinding endpoint configured to used Transport security mode with Certificate based client credential type and protect level set to EncryptAndSign <bindings> <netTcpBinding> <binding name="CertificateWithTransport" maxBufferPoolSize="100000000" maxBufferSize="100000000" maxReceivedMessageSize="100000000" portSharingEnabled="true"> <readerQuotas maxDepth="100000000" maxStringContentLength="100000000" maxArrayLength="100000000" maxBytesPerRead="100000000" maxNameTableCharCount="100000000" /> <security mode="Transport"> <transport clientCredentialType="Certificate" protectionLevel="EncryptAndSign"/> </security> </binding> </netTcpBinding> </bindings> Thanks      -= JL =-

SSIS Package Protection Level Errors - decrypt protected XML node "DTS:Password" with error 0x800900

Error 7 Error loading GetData.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.   c:\Packages\GetData.dtsx 1 1  Error 8 Validation error. Data Flow Task: OLEDB Source [5310]: The AcquireConnection method call to the connection manager "SourceServer" failed with error code 0xC0202009. GetData.dtsx 0 0 Environment I need to execute - BIDSHave Solution, with files linked with VSS. When I click on package, aforesaid errors show up and package opens in designed.Protection Level : Encrypt Sesitive with User KeyThis means it'd run only on machine and by user where and who created respectively.So I changed it to Encrypt Sesitive with Passoword and provided Passoword. No luckSo I changed it to Do not save sensitive, as anyways in the connection manager, it has Expression saying @Variablename (with appropriate correct syntax), and variable is mapped to config file. I tired with Config file and also by hardcoding the value in the connection manager's connection string after removing the variable name, also tried by hardcoding value in variable value and disabling config file.Nothing works. I read 3 threads discussing this issue by othe

Error: There are no page layout files available in the master page library of the top-level site.

I exported one of the subsite using stsadm and imported into a new site collection, I could access the new site collection but whenever I try to create a new page in my new site collection I get the following error.

There are no page layout files available in the master page library of the top-level site. Add one or more page layouts to this library before you create a page or set page properties.

Please help. Thanks.

build error allowDefinition='MachineToApplication beyond app level, can be caused by virt directory


Hi I used the converter wizard in VS 2008 to  convert a web application from 2003.  I get one build  error as described above.  I went into IIS and created a virt directory but still get the error.  Any ideas?

Thanks Paul. 

transport layer error



We have an issue when exporting an olap report as a .gif file by using OWC 2003 object. To export we are using 'ExportPicture' method of OWC object.  But we are getting following error


- An error was encountered in the transport layer.
- The peer prematurely closed the connection


We are using SSAS 2005 server.

We already tried some attempts, but they did not help:

  • The IE in client side already set : Enable Access Data Sources across domains in Security Settings
  • The connection string from OWC to Data Source is:
  • We are using MSOLAP.3 provider.
  • On Server Side, in SQL Native Client Configuration, the TCP/IP is set Enabled
  • Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is already on the ssas 2005 server.
  • In the server side, in Registry, below HKEY_CLASSES_ROOT \ MSOLAP \ CLSID has the same value with HKEY_CLASSES_ROOT \ MSOLAP.3 \ CLSID

Any suggestions on how to proceed.

Another ERROR Message Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'COLUMN'


Ok, I would like to ask you this if I may,

On another database I created a table named FICTION

and the table looks like this:


Now I am trying to change the data type in TITLE to CHAR(50)







Invalid at the top level of the document. Error processing resource


The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.


Invalid at the top level of the document. Error processing resource 'http://localhost:3167/Default.aspx'. Line 1, Position...


i get this error when created a XML document , though the fiel is created

Inconsistent error at some client location - Attempted to read or write protected memory


I am getting following error at some client. The error is very inconsistent and not able to reproduce locally(using test-harness). Can someone please guide me what could be the root cause of the problem?


Error Description

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.Exception Caught: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Assembly Name: System.Drawing.SafeNativeMethods+GdipAssembly File: System.Drawing.dllAssembly Version: Path: C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\\System.Drawing.dll.NET Version: v2.0.50727


Stack Trace

at System.Drawing.SafeNativeMethods.Gdip.GdipDrawRectangleI(HandleRef graphics, HandleRef pen, Int32 x, Int32 y, Int32 width, Int32 height)   at System.Drawing.Graphics.DrawRectangle(Pen pen, Int32 x, Int32 y, Int32 width, Int32 height)   at System.Windows.Forms.Control.PaintException(PaintEventArgs e)   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs)   at System.Windows.Forms.Control.WmPaint(Message& m)   at System.Windows.Forms.Control.WndProc(Message& m)   at System.Windows.Forms.Gr

How to display model level custom data annotation validation error?


Hello Experts,

I am a MVC newbie & am lost in various ways validation can be implemented in my application.

I created a custom model-level data annotation validator attribute, but am unable to display its error message in the view. Basically, I have let's say 5 properties in the Entity class Job (model-level custom attribute called UniqueKeywords defined on it):

1) LoginID: value comes in the URL

2) Title: Required property level attribute defined on it

3) CatID1, CatID2, CatID3 - 3 categoryIDs - these are dropdowns in the view with same list of keywords in all 3.

I want to mandate that the values picked by the user in all 3 category dropdowns should be different.

With reference to the code pasted below, here is the explanation of what happens:

When I submit the form without specifying a title or picking anything from any of the 3 category dropdowns, the validation occurs for the property level Required attribute as well as model level uniquekeywords attribute, but the error is displayed only next to the required field "Title". I can confirm that the custom validation also works by filling in some text in the Title field & then re-posting the form...this re-displays the view, but the error message "Category cannot be duplicated" is not displayed.

Looks like I am missing s

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend