provider: Named Pipes Provider, error: 40

• ashwani2k

  Newbie

  Points: 9

  More actions

  December 2, 2010 at 10:58 pm

  #241973

  Hi All,

  Please help to get out of this error..

  I am using sql server 2005 and visual studio 2010, visual studio is working perfectly but sql servr 2005 showing this error while i m trying to connect my local server ... but when i connect my server example 202.323.411.21 (my sql server remote access) it is working perfectly...... but y my local machine is not connected ....

  please help me.....

  .................................................error..............................................

  TITLE: Connect to Server

  ------------------------------

  Cannot connect to ESHU-PC.

  ------------------------------

  ADDITIONAL INFORMATION:

  A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (- Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

  .................................................error..............................................

  ----------------------------------------------------------------------------------------------

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  December 3, 2010 at 1:24 am

  #1258236

  Check your local server connectivity settings.

  You will find it in your start menu: MS SQL Server --> Configuration Tools --> SQL Server Configuration Manager.

  Select from the tree view on the left "SQL Server Network configuration" and enable some protocols for you local server.

  Hope this helps

  Gianluca

  -- Gianluca Sartori