Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Having problem connecting to SQL Server Express 2008 Expand / Collapse
Posted Tuesday, March 1, 2011 4:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 13, 2012 6:52 AM
Points: 7, Visits: 22

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
Post #1071096
Posted Tuesday, March 1, 2011 9:47 AM


Group: General Forum Members
Last Login: Thursday, December 8, 2016 9:45 AM
Points: 20, Visits: 394
Have you tried connecting using named pipes?

Post #1071378
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse