Can't connect to local computer via SQL Server 2008 Express Management Studio
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
Courtesy of Mark's comment:
I believe express editions run a named instance. You are specifying it in your connection string, right? Something like, (local)\SQLEXPRESS or 127.0.0.1\SQLEXPRESS?
From Microsoft http://technet.microsoft.com/en-us/library/ms165679(v=sql.90).aspx:
SQL Server Express is typically installed as a named instance. The default name of the instance is SQLExpress.