SQL Server LocalDB 2014 does not create a default instance at install

Question

I've recently downloaded and installed SQL Server LocalDB 2014 from Microsoft from here:

Microsoft® SQL Server® 2014 Express

After installation, there is not a default instance in the C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances directory.

But when I install 2012 version, it creates a v11.0 directory.

In 2014 case I should create an instance manually, but I want the default instance to be there automatically.

Any ideas for resolving this?

score 3 · Accepted Answer · answered Aug 07 '16 at 15:42

I found it.

If the MSSQLLocalDB folder is deleted some how from the Instances folder, it does not return when the SQL Server LocalDB 2014 is installed again.

But after installation, after first connection using the Datasource=(localdb)\MSSQLLocalDB connection string, the MSSQLLocalDB folder is recreated.

score 0 · Answer 2 · 2016-08-07T19:42:44.177

0

The default instance should be in : C:\Users\UserName\Local Settings\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB Folder.

File Locations for Default and Named Instances of SQL Server.

edited Aug 07 '16 at 19:42

answered Aug 07 '16 at 15:17

I dont want my server name. My Problem is there is no MSSQLLocalDB folder when I install sql localdb 2014 – MSL Aug 07 '16 at 19:00
I think you found it – Aug 07 '16 at 19:04

SQL Server LocalDB 2014 does not create a default instance at install

2 Answers2