Sql Server LocalDB Issue In Asp.NET MVC 4 Project

Question

I am getting the following error whenever I am trying to open the db_name.mdf file:

The database '{path}\db_name.MDF' cannot be opened because it is version 706. This server supports version 662 and earlier. A downgrade path is not supported. Could not open new database 'db_name.MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database for file {$path}\db_name.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Connection string as follows:

<add name="PasswordDBContext" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\db_name.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />

I am working on a asp.net mvc 4 project within visual studio.

Any help to get the issue resolved are very much appreciated. Thanks.

ok, thanks. So, do you think I should downgrade the mdf? will it work? — Rana
– Rana, Commented Jan 23, 2013 at 17:24

Community · Accepted Answer · 2017-05-23 12:29:43Z

3

LocalDB is a new feature introduced in SQL 2012 Express - you will need to install SQL 2012 Express LocalDb if you need to use an MDF in this manner.

Krzysztof Kozielczyk has blogged several entries around on LocalDB here - take note especially of the issues when running under 'Full IIS'.

IMO using LocalDb with ASP.NET is for a developer machine config only - i.e. when you are ready to deploy your (code first?) MVC 4 app to a testing or production environment, you should consider attaching ASPNETDB.MDF more permanently to a SQL Instance.

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Jan 23, 2013 at 19:02

StuartLC

108k18 gold badges225 silver badges294 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DJTN · Accepted Answer · 2014-03-30 16:49:44Z

You cannot attach a MVC 4 localDB in SQL Server 2012 Management Studio. You'll need to connect directly.

Open up SQL Server 2012 Management Studio. You can download a free express version here:

http://www.microsoft.com/en-us/download/details.aspx?id=29062

During installation make sure you check the localDB component to be installed.

After installation, open Management Studio and the "Connect to Server" dialog will appear.

Enter (LocalDb)\v11.0 in the Server Name textbox. Use windows authentication and click connect.

Your asp database will show in the manager. You can then script it out to what ever you want and edit the DB and make the appropriate changes to your connection strings in your web config.

Remember that if you're using Code First, which in VS 2013's MVC Internet template uses, you'll need to check your db creation code in your app start folder.

LocalDB was created so you can create data driven web applications without the overhead of a full version of SQL server running on your development machine. When you deploy to a production server, migrate to a full SQL Server instance.

Hope this helps :)

Sampath · Accepted Answer · 2013-01-23 14:47:15Z

0

Set your database connection string to your Locally installed DB is as below.

Web.config :

<add name="ContextName" connectionString="Data Source=ServerName;Initial Catalog=DBCatalogName;Integrated Security=True;MultipleActiveResultSets=True;App=EntityFramework"
       providerName="System.Data.SqlClient" />

answered Jan 23, 2013 at 14:47

Sampath

66.2k70 gold badges327 silver badges461 bronze badges

Collectives™ on Stack Overflow

Sql Server LocalDB Issue In Asp.NET MVC 4 Project

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related