server缺少sqlexpress sql,如果缺少MSSQLSERVER服务，如何连接到本地SQL Server？

I am trying to do some local development on various toy projects for learning purposes. I have Microsoft SQL Server Management Studio 2008 R2 (10.50.1617.0) and Visual Studio Express 2013 for Web installed on my machine. Projects using things such as Membership and Entity Framework code-first approach are failing to create databases. SSMS is configured to make connections to an external server with a bunch of my company's DBs on it, but I cannot connect to the local machine's SQL Server instance, which might be because it doesn't exist.

There is definitely no MSSQLSERVER service listed in the services list, which I assumed meant no instance of SQL Server was installed locally (even though I assumed VS 2013 or SSMS would have installed MSSQLSERVER?). This led me to download a copy of SQL Server 2012 Express LocalDB, but when I tried to install it, it failed, giving the following error:

Installation of SQL Server 2012 Express LocalDB failed because a higher version already exists on the machine. To proceed, uninstall the higher version and then run SQL Server 2012 Express LocalDB Setup again.

So I guess my question is, do I really have SQL Server installed? If so, how do I start the service (which is not even appearing in the services list) so that I can connect to it locally?

解决方案

Install Sql Server Express (free) edition (where the sql-server-express version matches your SSMS version).

I name my "instance" something besides "Express" or "SqlExpress" to avoid future complications.

MyComputerName\SqlExpress2008R2