Having problem connecting to SQL Server Express 2008

• Ish Fad

  Old Hand

  Points: 353

  More actions

  March 1, 2011 at 4:11 am

  #232764

  Hi

  I have Microsoft SQL Server Express 2008 running on my local pc with Windows XP professional.

  I started SQL Server Express 2008 from the service. I can see that server started.

  But when I try to connect from SQL Server Management Studio 2008, I am unable to get connction. I am getting following error;

  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. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

  (Microsoft SQL Server, Error:2)

  Please can some one help me. I am very new to sql server and I am lost here.

  many thanks

• Kavic62

  Right there with Babe

  Points: 754

  More actions

  March 1, 2011 at 9:47 am

  #1293048

  Have you tried connecting using named pipes?

  \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query