SQL Server Authentication problem(SQL server 2005)

• sreevani.chireddy

  SSC Journeyman

  Points: 82

  More actions

  July 17, 2008 at 6:39 am

  #189704

  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.

• Nick123-481228

  Mr or Mrs. 500

  Points: 581

  More actions

  July 17, 2008 at 6:53 am

  #844340

  Check your TCP/IP connection enabled in Server and client place which can be found in SQL server configurations.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  July 17, 2008 at 8:03 am

  #844413

  Other responses here: http://www.sqlservercentral.com/Forums/Topic535907-359-1.aspx

  Please do not cross post.