We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

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

Medium Priority
3,553 Views
Last Modified: 2013-12-17
Hi

I have a .Net 2.0 web application running several months fine. I use MSSQL 2005 server and asp.net.

Suddenly, I got an error message:
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.)

Was it hacked?

I checked the shared memory and name pipe started.

Error log:
2009-02-18 12:58:08.15 Logon       Error: 18452, Severity: 14, State: 1.
2009-02-18 12:58:08.15 Logon       Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012

Commented:
That usually occurs when the connection is dropped.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Kindly Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

This should resolve you out.
To do this, Right click Server in SSMS, choose Properties --> Security --> Choose Mixed mode Authentication
Technical Manager
Commented:
this kind of error comes randomly
maybe the connection object was garbage collected, because i know that the user credientials are part of the connection string so how is it possible that the user is not associated with the trusted sql server connection

no nothing was hacked

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
it was already Mixed mode Authentication

connection is dropped - It came from the following code:
string strSql = "select * FROM product";
DataSet ds = new DataSet();
try
{
ds = SqlHelper.ExecuteDataset(DBConnection.ConnString, CommandType.Text, strSql);
CollectionPager.DataSource = ds.Tables[0].DefaultView;
CollectionPager.BindToControl = ItemUserControl.PublicRepeaterInUC;
ItemUserControl.PublicRepeaterInUC.DataSource = CollectionPager.DataSourcePaged;
ds.Dispose();
ds = null;
}

Open in new window

hi,
 you could not do any thing for this error due to network connectivity issues only. this is common issue not only for sql server . smtp also you can get this error.
these type situation you could not log this error to database. use some text file based log and find the statistics
 
 

Author

Commented:
after one hour of the transport level error, it throws another error.

timeout period elapsed prior to completion of the operation or server is not responsing.

as in those time period, the web site needs to process 40 insert records in every 20 seconds

how should i fix it?
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.