ContosoUniversity
ContosoUniversity copied to clipboard
SQL Express 2014 automatic instance is named MSSQLLocalDB.
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" />
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