SQL 2014 LocalDB Error: “Cannot connect to (localdb)v12.O.”

Had been using SQL Local DB 2012 with a connection string (localdb)\v11.0 and thought it should be simple after installing SQL Local DB 2014 to change the connection string to (localdb)\v12.0 and have it “just work”. Not quite, SQL Management Studio allowed me to connect using (localdb)\v11.0 but gave me a crazy error when I tried to connect using (localdb)\v12.0 .. it said:

 

cannot connect localdb v12

or

Cannot connect to (locaIdb)v12.O.
Additional information:
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: SQL Network Interfaces, error: 50 –
Local Database Runtime error occurred. The specified LocalDB instance does not exist.
) (Microsoft SQL Server)

The message is a little ludicrous since local DB is not designed to be used for remote connections, and this was a local DB on a local PC. Turns out there’s a bug in the current release of SQL Local DB 2014 that was reported here:

http://connect.microsoft.com/SQLServer/feedback/details/845278/sql-server-2014-express-localdb-does-not-create-automatic-instance-v12-0

and there’s also a simple workaround there that worked for me; just go to a command prompt, and type:

sqllocaldb create "v12.0"

you then see this and all is well again.

sql local db

Advertisements