Post reply

SQL Server Authentication problem(SQL server 2005)

  • July 17, 2008 at 6:39 am

    #188202

    Hi, I'm having trouble to access my DB(SQL server 2005). I prefer to use SQL Server Authentication over windows Authentication. The problem I'm facing is that when I am loging in this SQL server Authentication mode it is showing message box like

    can not connect to .....

    " A connection was successfully established with the server.But then an error occurred during the login process.(provider:Shared memory provider;error:0- No process is on the other end of the pipe.)Microsoft Sql server,Error :233)

    I'm VERY new (first tme) to SQL Server, so this is all very foreign to me.can any one help me please.

  • July 17, 2008 at 6:52 am

    #844338

    It looks like you are conntecting using named pipes, have you enabled this in SQL configuration manager on your server?

  • July 17, 2008 at 7:03 am

    #844352

    sreevani.chireddy (7/17/2008)

    Hi, I'm having trouble to access my DB(SQL server 2005). I prefer to use SQL Server Authentication over windows Authentication. The problem I'm facing is that when I am loging in this SQL server Authentication mode it is showing message box like

    can not connect to .....

    " A connection was successfully established with the server.But then an error occurred during the login process.(provider:Shared memory provider;error:0- No process is on the other end of the pipe.)Microsoft Sql server,Error :233)

    I'm VERY new (first tme) to SQL Server, so this is all very foreign to me.can any one help me please.

    don't do double post! plz!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • July 17, 2008 at 7:15 am

    #844366

    Check the Shared Memory is enable in your SQL Server Configuration Manager

    Start->All Programs->Microsoft SQL Server 2005-> Configuration Tools -> SQL Server Configuration Manager and click Protocols for your_server_name and you will see the information about Shared Memory and also TCP\IP etc etc

    Let us to know the results!

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • July 17, 2008 at 10:48 pm

    #844772

    sorry me also facing the same problem.

  • July 17, 2008 at 10:49 pm

    #844773

    hi All

    i have changed my settings as u said.

    i got solution for this. thank u for your responses.

  • July 18, 2008 at 4:51 am

    #844907

    sreevani.chireddy what is you problem with too many posts triple posts ????

    :w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

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