Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Problem connecting to SQL Server Express 2008

Author  Topic 

Ish
Starting Member

11 Posts

Posted - 2011-03-01 : 06:22:31
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

Sachin.Nand

2937 Posts

Posted - 2011-03-01 : 06:43:46
In SQL Configuration Manager is Shared Memory Enabled ?

PBUH

Go to Top of Page
   

- Advertisement -