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.