'No process is on the other end of the pipe'

  • When I try to log in to one instance of SQL Server as anything other than sa*, I get the following error message (hopefully attached). Short version is

    a connection was successfully established with the server, but then an error occurred during the login process. No process is on the other end of the pipe.

    I've Googled it but haven't found much.

    SQL Server 2008 Standard Edition.

    Mixed authentication mode is ON.

    Max user connections is set to 0 (unlimited)

    The password is correct.

    Shared Memory is enabled

    Named Pipes is enabled

    TCP/IP is enabled

    VIA is disabled

    Any ideas please?

    * edit: Windows authentication works fine. It's just SQL Server authentication that seems to cause this.

  • Is this a remote connection? It sounds like a named instance, so have you got the SQL Server Browser service running?

    Have you checked that Named Pipes is enabled for the Network Configuration?

    http://msdn.microsoft.com/en-us/library/ms175496(v=sql.105).aspx

    Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]

  • Weirdly it's not a remote connection, but I can see why you're asking. Thanks though. It seems to be puzzling people all over the internet because I haven't found an answer yet! (It's not urgent, I have a workaround, but it's bugging me.)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply