Search code examples
visual-studiovisual-studio-2017localdbsql-server-2016-localdb

Unable to create a database in Visual Studio 2017

I installed Visual Studio 2017 with Desktop componennts + SQL Server 2016 Express LocalDb option.

However, when I try to create a database from the Data Connections option from Server Explorer Toolbar, I get this error message:

enter image description here

What is going on, why after default installation of VS2017 I cannot create a database?

Solution

  • Microsoft changed their versioning scheme:

    Older versions used their version number, for example (LocalDB)\v11.0, the most recent version changed that and switched to (LocalDb)\MSSQLLocalDb as the server name in the connection string section and in the entityFramework section the new value is parameter value="mssqllocaldb" ' .