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

Posted on 2009-02-17
Last Modified: 2013-12-17

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

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>]
Question by:techques
    LVL 75

    Expert Comment

    by:Anthony Perkins
    That usually occurs when the connection is dropped.
    LVL 57

    Expert Comment

    by:Raja Jegan R
    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
    LVL 26

    Accepted Solution

    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

    Author Comment

    it was already Mixed mode Authentication

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

    Open in new window

    LVL 5

    Expert Comment

     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 Comment

    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?

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now