Search code examples
sqlsql-serverlocaldb

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

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?

Solution

  • 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.