I have SQL Server 2014 installed, and I am trying to connect to a 2014 database in Visual Studio. If I try to use (under the advanced button) LocalDB\v11
, then the version number is wrong. When I try to use the SQLEXPRESS
(default name) instance (with user instance turned on, otherwise it complains that a database with that name already exists) it will connect, but when I try to run the web service it errors "unable to launch ISS server". So neither option works.
How can I get Visual Studio to recognize the SQL Server 2014 localDB?
I think
(localdb)\MSSQLLocalDB
should work. That seems to be the name of the automatic LocalDB instance in SQL Server 2014 (and probably going forward as well).