ContosoUniversity icon indicating copy to clipboard operation
ContosoUniversity copied to clipboard

SQL Express 2014 automatic instance is named MSSQLLocalDB.

Open StevenTCramer opened this issue 9 years ago • 1 comments

According to https://msdn.microsoft.com/en-us/library/hh510202(v=sql.120).aspx the name of SQL Express 2014 automatic instance is MSSQLLocalDB and not V12.0.

I would recommend that the web.config shipped be updated to use this. More likely to run right out of the box.

Change: <add name="SchoolContext" connectionString="Data Source=(LocalDb)\v12.0;Initial Catalog=ContosoUniversity;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />

TO <add name="SchoolContext" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=ContosoUniversity;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />

StevenTCramer avatar Jun 20 '15 22:06 StevenTCramer

Hi @StevenTCramer for this demo app you can too create a new instance via cmd using SqlLocalDB.exe in the SQL Server Folder Tools/Binn

SqlLocalDB create v12.0

ghost avatar Mar 07 '16 00:03 ghost