Post reply

Connection Error- No process at other end of pipe...

  • August 12, 2011 at 1:47 am

    #255653

    I was trying to connect Another instance of SQL Server which is on the another Machine. Its Giving error...

    A Connection was successfully Established with the server, but the error occurred during the login process. (provider: Named Pipes Provider, error: 0No process is on other end of pipe.)(Microsoft SQL Server,Error:203)

    I did troubleshooting by checking pipes.

    I have set login rights on that instance as sysadmin .

    I checked Port number.

    Still same error poping up.

    I have created a named instance on my machine. I am getting connected to it. But If I tried to connect instance on another machine. I am getting above error.

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

  • August 12, 2011 at 1:52 am

    #1367747

    Check whether the TCP\IP protocol is enabled.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

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

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