Can't connect to local computer via SQL Server 2008 Express Management Studio

Question

HI, folks,

Previously, I had a SQL Server 2008 installed, but then I deleted it, and installed SQL Server 2008 Express Management Studio. And now I can't connect to local computer. I get error :

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

But I can create DB via VS2010.

Answer 1

SQL Server Express editions install by default without TCP/IP connectivity. If your database service is running on one compute and the management studio is on another, you will need to enable TCP/IP using the SQL Server Configuration Manager.