Connection Problem

• VastSQL

  SSC-Dedicated

  Points: 36122

  More actions

  July 13, 2007 at 8:42 am

  #175227

  Hi,

   

  Am having a local SQL EXPRESS SERVER which was working fine but when i tried to open a new query window its throwing an error given below

   

   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.)  Techinal Details: System.Data.SqlClient.SqlException: 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.)

   

  But its get solved after sometime and again repeating later.

   

  Please help me

   

  R.K.Nair

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 17, 2007 at 5:24 am

  #719969

  Check if shared memory protocol is enabled if not enable it so that you will be able to connect. Also try connecting thru TCP/IP.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com