Cannot connect remotely to SQL Express 2005

• tripower

  SSCrazy

  Points: 2035

  More actions

  July 25, 2010 at 3:01 pm

  #144203

  When I try to connect to another computer on my home network running SSEXP 2005 I get the following:

  The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following the client tried to connect to an unsupported version of sql server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: named pipes provider, error:0 –no process is no the other end of the pipe.) (Microsoft sql server, error:233)

  I can connect fine locally, but not from another box using Management Studio. Any assistance please.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 25, 2010 at 8:58 pm

  #1197990

  Check if the remote connections are enabled or not.

  This article explains how to configure it.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga