Connecting Visual Studio 2010 with Sql server 2012

Question

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?

Answer 1

Hi, I was selecting "Microsoft Sql Server Database File" as Data Source and
getting an above error. When I selected Microsoft Sql Server as Data Source,
error disappeared. Now I am able to connect..