Click here to Skip to main content
15,560,426 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I am not able to connect sql server 2012 database with visual studio 2010 ultimate version. I have installed VS 2010 service pack 1 while installing sql server 2012. I am getting below error:

"The database C:/USERS/SACHIN/DOCUMENTS/First_Database.mdf can not be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database C:/USERS/SACHIN/DOCUMENTS/First_Database.mdf.CREATE DATABASE is aborted. An attempt to attach an auto-named database for file C:/USERS/SACHIN/DOCUMENTS/First_Database.mdf failed. A database with the same name exists or specified file can not be opened, or it is located on UNC share."

Can you please let me know the reason for the error and how to resolve it?
Posted
Updated 24-May-13 16:58pm
v2

1 solution

This is because your database is from SQL Server 2012. The only way to resolve this as I found is to Generate Script from SQL Server 2012 then run it in SQL Server 2008 R2.


--Amit
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900