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

when i enter the user name, Password and click enter in my site

it showing below error..

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 may be the problem..

This does not sound like a SQL Server problem, it's more likely something is acting up in the network.

Have a look at 2 links below if it still fail after few retries:
http://www.mcse.ms/message2316445.html
http://channel9.msdn.com/ShowPost.aspx?PostID=243278

|||

i am accessing the site through internet..

if i reload the error page it loading successfully..

sql

A transport-level error has occurred when sending the request to the server.

Hi,

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 am using a direct connection from my Gridview to perform a huge database search. the stored procedure will take 10- 60 seconds to execute the query.

What the problem i am facing is when the sp takes long time (more than 1 minutes), then when i try any other operation like calling another sp frm another page, i am getting the above specified error.

Anybody can tell why is it happening?

here my code snippet goes

<asp:GridView ID="searchGV" runat="server" AllowPaging="True" AllowSorting="True"

BorderColor="#999999" BorderStyle="None" CellPadding="3" Width="100%" AutoGenerateColumns="False" DataSourceID="searchObj" DataKeyNames="Recordnumber" OnDataBound="searchGV_DataBound" OnPageIndexChanged="searchGV_PageIndexChanged">

<RowStyle CssClass="gridRow" />

<PagerStyle HorizontalAlign="Center" BackColor="#999999" ForeColor="Black" />

<HeaderStyle CssClass="gridHeader" />

<AlternatingRowStyle CssClass="gridAlternateRow" />

<Columns>

<asp:TemplateField HeaderText="All">

<HeaderTemplate>

<asp:CheckBox ID="chkid" AutoPostBack="true" OnCheckedChanged ="OnCheckChangedEvent" runat="server" />

</HeaderTemplate>

<EditItemTemplate>

<asp:CheckBox ID="chkSelect" runat="server" />

</EditItemTemplate>

<ItemTemplate>

<asp:CheckBox ID="chkSelect" runat="server"/>

</ItemTemplate>

<ControlStyle Height="18px" Width="15px" />

<ItemStyle Width="5px" />

</asp:TemplateField>

<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title">

<ItemStyle Width="150px" />

</asp:BoundField>

<asp:BoundField DataField="Artist" HeaderText="Artist(s)" SortExpression="Artist"/>

<asp:BoundField DataField="Album" HeaderText="Album" SortExpression="Album"/>

<asp:BoundField DataField="Writer" HeaderText="Writer(s)" SortExpression="Writer" ><ItemStyle Width="150px" /></asp:BoundField>

<asp:BoundField DataField="ISRC" HeaderText="ISRC" SortExpression="ISRC" />

<asp:BoundField DataField="UPC" HeaderText="UPC" SortExpression="UPC"/>

<asp:BoundField DataField="PLineLabel" HeaderText="P-Line Label" SortExpression="PLineLabel" ><ItemStyle Width="100px" /></asp:BoundField>

<asp:BoundField DataField="DistLabel" HeaderText="Distribution Label" SortExpression="DistLabel" >

<ItemStyle Width="100px" />

</asp:BoundField>

<asp:BoundField DataField="PublishInfo" HeaderText="Publisher(s)" SortExpression="PublishInfo" />

<asp:BoundField DataField="Recordnumber" HeaderText="Record Number" SortExpression="Recordnumber" />

<%-- <asp:BoundField DataField="UID" HeaderText="UID" Visible="false" />--%>

</Columns>

</asp:GridView>

with adapter

<asp:SqlDataSource ID="searchObj" runat="server" SelectCommand="gsp_titleSearchResult" SelectCommandType="StoredProcedure" ConnectionString="<%$ ConnectionStrings:ConnStr %>">

<SelectParameters>

<asp:ControlParameter ControlID="HuserID" PropertyName="Value" Name="Userid" Type="String" Size="50" DefaultValue="" />

<asp:ControlParameter ControlID="Htitle" PropertyName="Value" Name="title" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hartist" PropertyName="Value" Name="artist" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Halbum" PropertyName="Value" Name="album" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hwriter" PropertyName="Value" Name="writer" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hisrc" PropertyName="Value" Name="isrc" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hupc" PropertyName="Value" Name="upc" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hpline" PropertyName="Value" Name="pline" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hdist" PropertyName="Value" Name="distlabel" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="Hpublish" PropertyName="Value" Name="publisher" Type="String" Size="50" DefaultValue=" " />

<asp:ControlParameter ControlID="ReleaseID" PropertyName="Value" Name="Releaseid" Type="Int32" Size="50" DefaultValue="0" />

<asp:ControlParameter ControlID="RecordLabelID" PropertyName="Value" Name="recordlabelid" Type="Int32" Size="50" DefaultValue="0" />

<asp:ControlParameter ControlID="PublisherID" PropertyName="Value" Name="Publisherid" Type="Int32" Size="50" DefaultValue="0" />

<asp:ControlParameter ControlID="ArtistID" PropertyName="Value" Name="Artistid" Type="Int32" Size="50" DefaultValue="0" />

</SelectParameters>

</asp:SqlDataSource>

Advance thanks

Anvar Sadath

Make sure that if you are using connection pooling the pool size does not hit the configured limit. If you are making use of extensive locking within the procedure (or even SQL Server does) you will get a timeout for the other procedure / statement, waiting for ressources. Try to find out if the procedure does locking using sp_lock or Acitivity monitor or if deadlock are occuring during execution time.

Jens K. Suessmeyer

http://www.sqlserver2005.de

A transport-level error has occurred when sending the request to the server

Hi all,

I am new to SQL 2005. I have one issue and it is as follows:

I write a simple query and run it; it works fine.

Now I break the network connection and run the query; in this case it runs fine.

But when I reconnect the network and run the query, then I get an error as follows:

"A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - An unexpected network error occurred.) "

Every thing is local here. So how the network issue comes here?

For some reason the connection was made through Named Pipes instead of Shared Memory (the default for local connections), which suggests that SqlClient did not recognize the connection was local, and most likely tunneled Named Pipes over TCP, hence, disocnnecting the network has impact.

How do you specify the server name - perhaps by its fully qualified domain name (FQDN), or IP address?

If you specify it by the hostname or "." or "(local)" SqlClient should recognize the local connection, and you should not see the error.

|||

Hi ,

sorry to reply late.

I tried the above mentioned case. In case of "." or "(local)" it did not connect to the SQL server. When I try it by the host name then same original problem persist.

Thanks

|||

Well sorry once again!!!

I made some mistake in the above reply.

I tried as mentioned in the solution and here are the results:

In case of "." it works fine

In case of host name the problem still persists.

for "(local)" I have not yet tested.

Thanks

|||

Regarding the host name problem - do you specify the server name exactly the same way as returned by the Windows hostname command-line command?

|||

Yes, I specify the server name exactly as returned by the the windows hostname command-line command. But the problem still persists.

|||

Great post ~ I had the same problem.

When trying to connect to a local SQL Server I was using 'localhost', which resulted in "A transport-level error has occurred...".

To resolve, I replaced 'localhost' with '(local)', as suggested.

Regards.

|||I same the same problem but I am connecting to remote server using IP, any idea?

A transport-level error has occurred when sending the request to the server

I've tried to search on the web for a solution for this error but i didn't find any working solutions for this problem. We have 2 servers. The first one is the server we use to develop our ASP.NET 2 application. On this server we don't have this error. On the other server (use by our client) we have this error sometime and i don't know why. Both servers have the same configuration and both application have the same web.config file.

I've tried to add a try-catch and retry the query when the error occured. This seems to be working but we don't want to have to change all our connections and since we don't have this problem on the other server we want to find the source of the problem.

Any idea ?

Thanks !

The most frequent cause of this error is restarting SQL Server. Another known cause is altering a database, e.g. from READ_ONLY to READ_WRITE, or taking a database offline/online.

Do any of these apply to your case?

A transport-level error has occurred when sending the request to the server

Hi all,

I am new to SQL 2005. I have one issue and it is as follows:

I write a simple query and run it; it works fine.

Now I break the network connection and run the query; in this case it runs fine.

But when I reconnect the network and run the query, then I get an error as follows:

"A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 0 - An unexpected network error occurred.) "

Every thing is local here. So how the network issue comes here?

For some reason the connection was made through Named Pipes instead of Shared Memory (the default for local connections), which suggests that SqlClient did not recognize the connection was local, and most likely tunneled Named Pipes over TCP, hence, disocnnecting the network has impact.

How do you specify the server name - perhaps by its fully qualified domain name (FQDN), or IP address?

If you specify it by the hostname or "." or "(local)" SqlClient should recognize the local connection, and you should not see the error.

|||

Hi ,

sorry to reply late.

I tried the above mentioned case. In case of "." or "(local)" it did not connect to the SQL server. When I try it by the host name then same original problem persist.

Thanks

|||

Well sorry once again!!!

I made some mistake in the above reply.

I tried as mentioned in the solution and here are the results:

In case of "." it works fine

In case of host name the problem still persists.

for "(local)" I have not yet tested.

Thanks

|||

Regarding the host name problem - do you specify the server name exactly the same way as returned by the Windows hostname command-line command?

|||

Yes, I specify the server name exactly as returned by the the windows hostname command-line command. But the problem still persists.

|||

Great post ~ I had the same problem.

When trying to connect to a local SQL Server I was using 'localhost', which resulted in "A transport-level error has occurred...".

To resolve, I replaced 'localhost' with '(local)', as suggested.

Regards.

|||I same the same problem but I am connecting to remote server using IP, any idea?

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

Hi,

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

Sudhakar

Hi Sudhakar

Please can you be a little more specific.

Are you getting this error in SQL Query Analyzer? Are you getting this from some sort of Access or .NET front end application? Or is it from an ASP application?

if you provide a little more info im sure we can work this out.

Barry

|||Hi Barry,

I had developed a Web Application using ASP.Net 2005 and using SQL Server 2005 as backend ,

Please review the following code:

**************************************************************

Try
Dim con As New SqlConnection("server=101998-WEB1;database=TriMark;Integrated Security=SSPI")
con.Open()
Dim da As New SqlDataAdapter("select * from tblusers", con)
Dim ds As New DataSet
da.Fill(ds)
Catch ex As Exception
Response.Write(ex.Message)
End Try

*************************************************************

I was getting fllowing error when we try to fetch data from the database through .net application.

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 to sort out this?

Waiting for your response

Sudhakar

|||

Hi, Sudhakar

To lock down the issue, can you provide the stack info when the error occured? Also, can you following the blog:http://blogs.msdn.com/sql_protocols/archive/2006/08/04/688396.aspx.

to collect ETW trace and send it to protcols@.microsoft.com

Thanks!

Ming.

|||

Is there any possibility the application uses one connection from multiple threads?

If one thread closed the connection, and another tried to use it it could generate this error.

|||Sudhakar, Can you please share with me your findings on this issue. I am seeing similar issue randomly Thanks.sql

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

Hi,

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

Sudhakar

Hi Sudhakar

Please can you be a little more specific.

Are you getting this error in SQL Query Analyzer? Are you getting this from some sort of Access or .NET front end application? Or is it from an ASP application?

if you provide a little more info im sure we can work this out.

Barry

|||Hi Barry,

I had developed a Web Application using ASP.Net 2005 and using SQL Server 2005 as backend ,

Please review the following code:

**************************************************************

Try
Dim con As New SqlConnection("server=101998-WEB1;database=TriMark;Integrated Security=SSPI")
con.Open()
Dim da As New SqlDataAdapter("select * from tblusers", con)
Dim ds As New DataSet
da.Fill(ds)
Catch ex As Exception
Response.Write(ex.Message)
End Try

*************************************************************

I was getting fllowing error when we try to fetch data from the database through .net application.

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 to sort out this?

Waiting for your response

Sudhakar

|||

Hi, Sudhakar

To lock down the issue, can you provide the stack info when the error occured? Also, can you following the blog:http://blogs.msdn.com/sql_protocols/archive/2006/08/04/688396.aspx.

to collect ETW trace and send it to protcols@.microsoft.com

Thanks!

Ming.

|||

Is there any possibility the application uses one connection from multiple threads?

If one thread closed the connection, and another tried to use it it could generate this error.

|||Sudhakar, Can you please share with me your findings on this issue. I am seeing similar issue randomly Thanks.

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

Hi,

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

Sudhakar

Hi Sudhakar

Please can you be a little more specific.

Are you getting this error in SQL Query Analyzer? Are you getting this from some sort of Access or .NET front end application? Or is it from an ASP application?

if you provide a little more info im sure we can work this out.

Barry

|||Hi Barry,

I had developed a Web Application using ASP.Net 2005 and using SQL Server 2005 as backend ,

Please review the following code:

**************************************************************

Try
Dim con As New SqlConnection("server=101998-WEB1;database=TriMark;Integrated Security=SSPI")
con.Open()
Dim da As New SqlDataAdapter("select * from tblusers", con)
Dim ds As New DataSet
da.Fill(ds)
Catch ex As Exception
Response.Write(ex.Message)
End Try

*************************************************************

I was getting fllowing error when we try to fetch data from the database through .net application.

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 to sort out this?

Waiting for your response

Sudhakar

|||

Hi, Sudhakar

To lock down the issue, can you provide the stack info when the error occured? Also, can you following the blog:http://blogs.msdn.com/sql_protocols/archive/2006/08/04/688396.aspx.

to collect ETW trace and send it to protcols@.microsoft.com

Thanks!

Ming.

|||

Is there any possibility the application uses one connection from multiple threads?

If one thread closed the connection, and another tried to use it it could generate this error.

|||Sudhakar, Can you please share with me your findings on this issue. I am seeing similar issue randomly Thanks.

A transport-level error has occurred when receiving results from the server. - after insta

We've devoted a resource to this today, but I have to believe it's something easy that we're overlooking. The scneario is that we have a production Web application that until last weekend had a SQL 2000 back end. This weekend we installed a new instance of SQL 2005 and everything works (we tested in a sandbox environment, but someone must not have load tested enough) and never saw these exceptions.

So, after the upgrade we now receive 100's of thexe SQL excptions per day:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

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

Does anyone know what we've overlooked that's causing this issue?

Thanks for any help!

If such exceptions occur only when machines running Win2K/WinXP, you can take a look at this KB:

http://support.microsoft.com/kb/919710

If the SQL Server is running on Win2003 SP1 and all cilents may encounter such issue, try to use the regedit.exe utility to add a new DWORD value namedSynAttackProtect to the registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\ with value data of 00000000.

|||

Joy. We found the problem today. In efforts to improve the performance of the aspnet_xxx sprocs, we added (with nolock) to many of them. This helped tremendously in SQL 2000. It killed us when moving to 2005. Removing this fromaspnet_Profile_GetProperties solved the problem. There were more things we'd found along the way after I posted this, like with health monitoring and analysis of the SQL logs, we saw that MANY of our profiles were not being decoded as they were corrupt - not being fully read from the DB. Anyway, this explains why no one else on the Web is talking about the subject, as recommended--they probably did modify their aspnet_xxx sprocs.

A transport-level error has occurred when receiving results from the server.

Hi all,
I am getting the error below:
I would like to also mention that this error is occuring randomly. I am
running a web application under SQL Server 2005 and .NET framework 2.0.
Has anyone encountered this issue.
Error occurred during report data retrieving and binding.
The actual error message is:
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.)
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSni Error(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni (DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPac ket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlM etaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeade r(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHead er(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int 32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueIntern al(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Obje ct[] values) at
System.Data.ProviderBase.DataReaderContainer.Commo nLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow () at
System.Data.Common.DataAdapter.FillLoadDataRow(Sch emaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(Data Set dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at private_enterprise_report_cmn_RepricingSummary.Pag e_Load(Object
sender, EventArgs e) in
*** Sent via Developersdex http://www.codecomments.com ***
You would want to check the SQL Server error logs to make
sure it's not a refused connection from an issue like full
logs, out of disk space, etc. Those would be in the SQL log.
If you don't have anything there and it's random then you
may be experiencing network burps and dropping connections.
You can following the troubleshooting steps in the following
article:
How to troubleshoot network connectivity problems
http://support.microsoft.com/?id=325487
-Sue
On Mon, 23 Apr 2007 13:27:10 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:

>Hi all,
>I am getting the error below:
>I would like to also mention that this error is occuring randomly. I am
>running a web application under SQL Server 2005 and .NET framework 2.0.
>Has anyone encountered this issue.
>Error occurred during report data retrieving and binding.
>The actual error message is:
>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.)
>at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
>Boolean breakConnection) at
>System.Data.SqlClient.TdsParser.ThrowExceptionAnd Warning(TdsParserStateO
>bject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn iError(TdsParserStateOb
>ject stateObj, UInt32 error) at
>System.Data.SqlClient.TdsParserStateObject.ReadSn i(DbAsyncResult
>asyncResult, TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadPa cket(Int32
>bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByt e()
>at System.Data.SqlClient.TdsParser.GetTokenLength(Byt e token,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.GetDataLength(Sql MetaDataPriv colmeta,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.ProcessColumnHead er(SqlMetaDataPriv col,
>TdsParserStateObject stateObj, Boolean& isNull) at
>System.Data.SqlClient.SqlDataReader.ReadColumnHea der(Int32 i) at
>System.Data.SqlClient.SqlDataReader.ReadColumn(In t32 i, Boolean
>setTimeout) at
>System.Data.SqlClient.SqlDataReader.GetValueInter nal(Int32 i) at
>System.Data.SqlClient.SqlDataReader.GetValues(Obj ect[] values) at
>System.Data.ProviderBase.DataReaderContainer.Comm onLanguageSubsetDataRea
>der.GetValues(Object[] values) at
>System.Data.ProviderBase.SchemaMapping.LoadDataRo w() at
>System.Data.Common.DataAdapter.FillLoadDataRow(Sc hemaMapping mapping) at
>System.Data.Common.DataAdapter.FillFromReader(Dat aSet dataset, DataTable
>datatable, String srcTable, DataReaderContainer dataReader, Int32
>startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
>parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
>dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
>at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
>DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
>srcTable, IDbCommand command, CommandBehavior behavior) at
>System.Data.Common.DbDataAdapter.Fill(DataTable [] dataTables, Int32
>startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
>behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
>at private_enterprise_report_cmn_RepricingSummary.Pag e_Load(Object
>sender, EventArgs e) in
>*** Sent via Developersdex http://www.codecomments.com ***
|||I'm not sure if this is related to the issue but when I do try to
connect to my database server from a Remote Management Studio. I get the
same error
"A transport-level error has occurred when receiving results from the
server..."
Any ideas?
*** Sent via Developersdex http://www.codecomments.com ***
|||You still need to go through the other steps - check the
logs, check the network connectivity, etc.
-Sue
On Tue, 24 Apr 2007 06:32:28 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:

>I'm not sure if this is related to the issue but when I do try to
>connect to my database server from a Remote Management Studio. I get the
>same error
>"A transport-level error has occurred when receiving results from the
>server..."
>Any ideas?
>
>*** Sent via Developersdex http://www.codecomments.com ***
sql

A transport-level error has occurred when receiving results from the server.

Hi all,
I am getting the error below:
I would like to also mention that this error is occuring randomly. I am
running a web application under SQL Server 2005 and .NET framework 2.0.
Has anyone encountered this issue.
Error occurred during report data retrieving and binding.
The actual error message is:
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.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb
ject stateObj, UInt32 error) at
System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.GetDataLength(SqlMetaDataPriv colmeta,
TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.ProcessColumnHeader(SqlMetaDataPriv col,
TdsParserStateObject stateObj, Boolean& isNull) at
System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at
System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean
setTimeout) at
System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at
System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at
System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataRea
der.GetValues(Object[] values) at
System.Data.ProviderBase.SchemaMapping.LoadDataRow() at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at private_enterprise_report_cmn_RepricingS
ummary.Page_Load(Object
sender, EventArgs e) in
*** Sent via Developersdex http://www.codecomments.com ***You would want to check the SQL Server error logs to make
sure it's not a refused connection from an issue like full
logs, out of disk space, etc. Those would be in the SQL log.
If you don't have anything there and it's random then you
may be experiencing network burps and dropping connections.
You can following the troubleshooting steps in the following
article:
How to troubleshoot network connectivity problems
http://support.microsoft.com/?id=325487
-Sue
On Mon, 23 Apr 2007 13:27:10 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:

>Hi all,
>I am getting the error below:
>I would like to also mention that this error is occuring randomly. I am
>running a web application under SQL Server 2005 and .NET framework 2.0.
>Has anyone encountered this issue.
>Error occurred during report data retrieving and binding.
>The actual error message is:
>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.)
>at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>Boolean breakConnection) at
>System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
>bject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateOb
>ject stateObj, UInt32 error) at
>System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
>asyncResult, TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
>bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadByte()
>at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.GetDataLength(SqlMetaDataPriv colmeta,
>TdsParserStateObject stateObj) at
>System.Data.SqlClient.TdsParser.ProcessColumnHeader(SqlMetaDataPriv col,
>TdsParserStateObject stateObj, Boolean& isNull) at
>System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at
>System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean
>setTimeout) at
>System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) at
>System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) at
>System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataRea
>der.GetValues(Object[] values) at
>System.Data.ProviderBase.SchemaMapping.LoadDataRow() at
>System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at
>System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable
>datatable, String srcTable, DataReaderContainer dataReader, Int32
>startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
>parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[]
>dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
>at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
>DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
>srcTable, IDbCommand command, CommandBehavior behavior) at
>System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
>startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
>behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
>at private_enterprise_report_cmn_RepricingS
ummary.Page_Load(Object
>sender, EventArgs e) in
>*** Sent via Developersdex http://www.codecomments.com ***|||I'm not sure if this is related to the issue but when I do try to
connect to my database server from a Remote Management Studio. I get the
same error
"A transport-level error has occurred when receiving results from the
server..."
Any ideas?
*** Sent via Developersdex http://www.codecomments.com ***|||You still need to go through the other steps - check the
logs, check the network connectivity, etc.
-Sue
On Tue, 24 Apr 2007 06:32:28 -0700, Audrey Ng
<odd26uk@.yahoo.co.uk> wrote:

>I'm not sure if this is related to the issue but when I do try to
>connect to my database server from a Remote Management Studio. I get the
>same error
>"A transport-level error has occurred when receiving results from the
>server..."
>Any ideas?
>
>*** Sent via Developersdex http://www.codecomments.com ***

A transport-level error has occurred when receiving results from the server

Hi all,

I

am trying to run a stored procedure which retreives 3 lakhs of records

and updates the data and moves few of those records to some tables.

Since the number of records are more , the time taken for the storede

procedure is around 30 minutes when i directly execute it in query

analyzer.

But I need to execute it from Visula Studio.Net 2005

(c#). Whole of the application contains only one form with a single

button.When I click on the button , this stored procure has to be

executed. But I am getting an error as shown below.

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

Database used is SqlServer 2000

How to solve this error?. Any ideas are really appreciated.

Thanks and Regards,
Sukanya.

The error occured during data operation and the remote server either temporarily offline or close connection due to invalid client operation or your the permission your client to access the remote server resources has been changed, etc.

So, to identify the problem, you need :

1) Assume you were making remote connection, ping <remoteserver>, telnet <remoteserver> <sqlport>, or net view \\<remoteserver> or see firewall setting on the remote server to check whether the network is still good to make sure remote server is still reachable, and contact your network administrator to fix those problems.

2) You can give a retry by running your client app see whether the problem went away.

3) If 1) and 2) passed, you might open sql profile to nail down which client operation to cause sql server terminate connection, and check server errorlog or application event log find out any clue.

If you were making local connection, it is probably reason 3).

HTH.

Ming.

|||Hi,

I just increased the "connect timeout" in connectionstring of app.config to 1 hour. This solved my problem.

Thanks,
Sukanya

A transport-level error has occurred when receiving results from S

I am setting up a replication of a database which has 364 tables. The size of
this database is close to 150 GB.
I have one server as publisher.
I have another server which i am using for distributor as well as
subscriber. Both servers are seperate physical servers.
I tried replicating 2 tables, I don;' see any issue. They replicate with no
issue. However, when I try to replicate all tables I get this error on
snapshot agent.
Please advise if any one has already seen this problem. My both servers are
on SQL 2005 SP2.
Error messages:
Message: 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.)
Command Text:
set nocount on
declare @.source_object_id int
declare @.sync_object_id int
set @.source_object_id = object_id(quotename(@.source_object_schema) + N'.' +
quotename(@.source_object_name))
set @.sync_object_id = object_id(quotename(@.sync_object_schema) + N'.' +
quotename(@.sync_object_name))
declare @.partitioning_column sysname
declare @.partitioning_column_type sysname
declare @.qualified_source_object_name nvarchar(600)
declare @.partitioning_column_collation sysname
declare @.partitioning_index_name sysname
set @.qualified_source_object_name = quotename(@.source_object_schema) + N'.'
+ quotename(@.source_object_name)
set @.partitioning_column = null
set @.partitioning_column_type = null
set @.partitioning_index_name = null
select @.partitioning_column = sc.name,
@.partitioning_column_type = st.name,
@.partitioning_column_collation = sc.collation,
@.partitioning_index_name = si.name
from sysindexes si
inner join syscolumns sc
on index_col(@.qualified_source_object_name, si.indid, 1) = sc.name
inner join systypes st
on sc.xtype = st.xusertype
where si.id = @.source_object_id
and sc.id = @.sync_object_id
and si.indid = 1
and st.name in (N'uniqueidentifier', N'bit', N'tinyint', N'smallint',
N'int', N'smalldatetime', N'real', N'money', N'datetime', N'float', N'bit',
N'decimal', N'numeric', N'smallmoney', N'bigint', N'varbinary', N'varchar',
N'binary', N'char', N'timestamp', N'nvarchar', N'nchar')
and (@.use_primary_key_only = 0 or si.status & 2048 = 2048)
if @.partitioning_column is not null
begin
select @.partitioning_index_name, @.partitioning_column,
@.partitioning_column_type, @.partitioning_column_collation
dbcc show_statistics(@.qualified_source_object_name,
@.partitioning_index_name)
end
Parameters: @.source_object_name = E_QRTZ_TRIGGER_LISTENERS
@.source_object_schema = dbo
@.sync_object_name = syncobj_0x3238314643373630
@.sync_object_schema = dbo
@.use_primary_key_only = 1
Stack: at
Microsoft.SqlServer.Replication.AgentCore.ReMapSql Exception(SqlException e,
SqlCommand command)
at
Microsoft.SqlServer.Replication.AgentCore.AgentExe cuteReader(SqlCommand
command, Int32 queryTimeout, CommandBehavior commandBehavior)
at
Microsoft.SqlServer.Replication.AgentCore.ExecuteW ithOptionalResults(CommandSetupDelegate
commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32
queryTimeout, CommandBehavior commandBehavior)
at
Microsoft.SqlServer.Replication.AgentCore.ExecuteW ithOptionalResults(CommandSetupDelegate
commandSetupDelegate, ProcessResultsDelegate processResultsDelegate)
at
Microsoft.SqlServer.Replication.Snapshot.SqlServer .ArticleBcpPartitioningResolver.GatherBaseTableSta tistics()
at
Microsoft.SqlServer.Replication.Snapshot.SqlServer .ArticleBcpPartitioningResolver.ResolveArticleBcpP artitioningUsingKeyDistributionHistogram(BaseArtic leWrapper article, Boolean usePrimaryKeyOnly)
at
Microsoft.SqlServer.Replication.Snapshot.SqlServer .ArticleBcpPartitioningResolver.ResolveArticleBcpP artitioning(BaseArticleWrapper
article, Boolean usePrimaryKeyOnly)
at
Microsoft.SqlServer.Replication.Snapshot.SqlServer .BcpLoadHintAndPartitioningResolutionWorkerThreadP rovider.DoWork(WorkItem workItem)
at
Microsoft.SqlServer.Replication.WorkerThread.NonEx ceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.WorkerThread.Agent ThreadProc()
at
Microsoft.SqlServer.Replication.AgentCore.BaseAgen tThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 64)
Get help: http://help/64
Server NTFWEPSQLT1, Level 20, State 0, Line 0
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.) (Source: MSSQLServer, Error number: 64)
Get help: http://help/64
Sr DBA
Pier 1 Imports
mabbas@.Pier1.com
You had a network failure in the middle of your snapshot distribution. This
should clear the next time it runs. You might want to run ping -t to watch
to see how lossy your link is.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:B877BD9F-EE3C-456E-87A7-64BB17FC5C11@.microsoft.com...
>I am setting up a replication of a database which has 364 tables. The size
>of
> this database is close to 150 GB.
> I have one server as publisher.
> I have another server which i am using for distributor as well as
> subscriber. Both servers are seperate physical servers.
> I tried replicating 2 tables, I don;' see any issue. They replicate with
> no
> issue. However, when I try to replicate all tables I get this error on
> snapshot agent.
> Please advise if any one has already seen this problem. My both servers
> are
> on SQL 2005 SP2.
> --
> Error messages:
> Message: 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.)
> Command Text:
> set nocount on
> declare @.source_object_id int
> declare @.sync_object_id int
> set @.source_object_id = object_id(quotename(@.source_object_schema) + N'.'
> +
> quotename(@.source_object_name))
> set @.sync_object_id = object_id(quotename(@.sync_object_schema) + N'.' +
> quotename(@.sync_object_name))
> declare @.partitioning_column sysname
> declare @.partitioning_column_type sysname
> declare @.qualified_source_object_name nvarchar(600)
> declare @.partitioning_column_collation sysname
> declare @.partitioning_index_name sysname
> set @.qualified_source_object_name = quotename(@.source_object_schema) +
> N'.'
> + quotename(@.source_object_name)
> set @.partitioning_column = null
> set @.partitioning_column_type = null
> set @.partitioning_index_name = null
> select @.partitioning_column = sc.name,
> @.partitioning_column_type = st.name,
> @.partitioning_column_collation = sc.collation,
> @.partitioning_index_name = si.name
> from sysindexes si
> inner join syscolumns sc
> on index_col(@.qualified_source_object_name, si.indid, 1) = sc.name
> inner join systypes st
> on sc.xtype = st.xusertype
> where si.id = @.source_object_id
> and sc.id = @.sync_object_id
> and si.indid = 1
> and st.name in (N'uniqueidentifier', N'bit', N'tinyint',
> N'smallint',
> N'int', N'smalldatetime', N'real', N'money', N'datetime', N'float',
> N'bit',
> N'decimal', N'numeric', N'smallmoney', N'bigint', N'varbinary',
> N'varchar',
> N'binary', N'char', N'timestamp', N'nvarchar', N'nchar')
> and (@.use_primary_key_only = 0 or si.status & 2048 = 2048)
> if @.partitioning_column is not null
> begin
> select @.partitioning_index_name, @.partitioning_column,
> @.partitioning_column_type, @.partitioning_column_collation
> dbcc show_statistics(@.qualified_source_object_name,
> @.partitioning_index_name)
> end
> Parameters: @.source_object_name = E_QRTZ_TRIGGER_LISTENERS
> @.source_object_schema = dbo
> @.sync_object_name = syncobj_0x3238314643373630
> @.sync_object_schema = dbo
> @.use_primary_key_only = 1
> Stack: at
> Microsoft.SqlServer.Replication.AgentCore.ReMapSql Exception(SqlException
> e,
> SqlCommand command)
> at
> Microsoft.SqlServer.Replication.AgentCore.AgentExe cuteReader(SqlCommand
> command, Int32 queryTimeout, CommandBehavior commandBehavior)
> at
> Microsoft.SqlServer.Replication.AgentCore.ExecuteW ithOptionalResults(CommandSetupDelegate
> commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32
> queryTimeout, CommandBehavior commandBehavior)
> at
> Microsoft.SqlServer.Replication.AgentCore.ExecuteW ithOptionalResults(CommandSetupDelegate
> commandSetupDelegate, ProcessResultsDelegate processResultsDelegate)
> at
> Microsoft.SqlServer.Replication.Snapshot.SqlServer .ArticleBcpPartitioningResolver.GatherBaseTableSta tistics()
> at
> Microsoft.SqlServer.Replication.Snapshot.SqlServer .ArticleBcpPartitioningResolver.ResolveArticleBcpP artitioningUsingKeyDistributionHistogram(BaseArtic leWrapper
> article, Boolean usePrimaryKeyOnly)
> at
> Microsoft.SqlServer.Replication.Snapshot.SqlServer .ArticleBcpPartitioningResolver.ResolveArticleBcpP artitioning(BaseArticleWrapper
> article, Boolean usePrimaryKeyOnly)
> at
> Microsoft.SqlServer.Replication.Snapshot.SqlServer .BcpLoadHintAndPartitioningResolutionWorkerThreadP rovider.DoWork(WorkItem
> workItem)
> at
> Microsoft.SqlServer.Replication.WorkerThread.NonEx ceptionBasedAgentThreadProc()
> at Microsoft.SqlServer.Replication.WorkerThread.Agent ThreadProc()
> at
> Microsoft.SqlServer.Replication.AgentCore.BaseAgen tThread.AgentThreadProcWrapper()
> (Source: MSSQLServer, Error number: 64)
> Get help: http://help/64
> Server NTFWEPSQLT1, Level 20, State 0, Line 0
> 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.) (Source: MSSQLServer, Error number: 64)
> Get help: http://help/64
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
|||Hilary - Why then it always works when I replicate any small database or same
data base with few articles. I see no time outs when ping during replication.
Sr DBA
Pier 1 Imports
mabbas@.Pier1.com
"Hilary Cotter" wrote:

> You had a network failure in the middle of your snapshot distribution. This
> should clear the next time it runs. You might want to run ping -t to watch
> to see how lossy your link is.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Moh" <mabbas@.Pier1.com> wrote in message
> news:B877BD9F-EE3C-456E-87A7-64BB17FC5C11@.microsoft.com...
>
>
|||It really looks like a network failure somewhere. The ping-t command should
reveal network hiccups occurring during the snapshot application.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:C3B863FA-723D-4781-9A99-99FCA2DDB364@.microsoft.com...[vbcol=seagreen]
> Hilary - Why then it always works when I replicate any small database or
> same
> data base with few articles. I see no time outs when ping during
> replication.
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
>
> "Hilary Cotter" wrote:
|||Actually, the SQL Server could think it's under a DOS attack and start
killing off connections.
Check out section 5.1 of
http://download.microsoft.com/download/f/1/0/f10c4f60-630e-4153-bd53-c3010e4c513b/ReadmeSQLEXP2005.htm#sse_dbengine
for more information.
On Mar 19, 1:02 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> It really looks like a network failure somewhere. The ping-t command should
> reveal network hiccups occurring during the snapshot application.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Moh" <mab...@.Pier1.com> wrote in message
> news:C3B863FA-723D-4781-9A99-99FCA2DDB364@.microsoft.com...
>
>
>
>
>
>
>
>
>
> - Show quoted text -