CODEWITHSUNDEEP
asp.net-mvcentity-frameworkmdfdowngradeserver-explorer
3 rules
3 rules

Reputation: 1409

A downgrade path is not supported convert version 782 to 706 and earlier

I am creating one application where I have used ASP.NET MVC with Entity Framework 4.5.2 and trying to access the SQL Server but it gives me an error that I can't access any database so I just convert it to the single user mode.

Now after converting it to Single User mode the new error comes when I am trying to access in Server Explorer, Data Connections (Default Connection), it shows me the below dialog. I am not understand what is going wrong.

I have SQL Server version 11.0.2100.60.

Please some one help me to solve this issue!

enter image description here

Upvotes: 0

Views: 2903

Answers (2)

Jesse
Jesse

Reputation: 21

This worked for me (using Visual Studio 2015 community)...

  • In Server Explorer right-click the desired connection and select Modify Connection
  • Select Advanced Options
  • Change the Data Source to a different version (In my case it needed to be SQL express) press OK.

Hope it helps

Upvotes: 1

3 rules
3 rules

Reputation: 1409

Ufffff after so many solutions applied I found one from it.

Steps:

1) Change Instance name in Visual Studio Link:

Under Tools > Options > Database Tools > Data Connections > SQL Server Instance Name. set (LocalDB)\MSSQLLocalDB

2) Change your connection string:

From:

<add name="DefaultConnection" connectionString="Data Source=./SQLExpress;AttachDbFilename=|DataDirectory|\DBName.Service-20160924032113.mdf;Initial Catalog=DBName.Service-20160924032113;Integrated Security=True;"providerName="System.Data.SqlClient" />

To:

<add name="DefaultConnection" connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\DBName.Service-20160924032113.mdf;Initial Catalog=DBName.Service-20160924032113;Integrated Security=True;"providerName="System.Data.SqlClient" />

3) Remove User Instance=True from Connection String.

Thanks to James P and Mark Homer for excellent response.

Upvotes: 0

Related Questions