SQL Server version 612, 655? Can I keep SQL Server 2005 mdf file of version 612 in SQL Server 2008 express edition of version 655. Hot Network Questions.
I have Visual Studio 2008 installed on this workstation with SQL 2000, 2005 Express, 2008 Express and I think 2008 R2 (not sure if that is a version itselve or not) I will call that workstation HOME I created some tables in SQLEXPRESS through VS2008. I worked on this project on another workstation that I just installed VS2008 annd SQLEXPRESS 2008 and I know that was R2 Installed Visual Studio 2010 trial edition between the thiem I made the tables on HOME and tonight for the first time since that install I am now getting the 'cannot be opened becuase it is version Version 661. This Server supports version 655.' What to do now? I can opened SQLExpress 2008 management studio and it is running. So is my SQL 2000. The problem seems to be that after the VS2010 install neither VS2008 or VS2010 can connect to the SQLExpress 2008 What do I do now?
I can't remove sql 2000 because it is tied to several 3+ gig databases that will not work in Express. No, he was not consciously doing what you say. He was trying to access a 2008 R2 database from within Visual Studio 2010 trial edition, and getting the error.
Lots of people are having the same problem with Visual Studio 2010 Express, and it's frustrating that Microsoft refuses to understand the problem or provide any meaningful feedback. I had a similar problem with Visual Studio 2010 Express, and finally figured out the following: -- I had two versions of SQL Server running on my machine, 10 and 10_50 (R2). I didn't consciously install two versions. Perhaps it happened because I installed VWD 2010 Express first, and seeing no SQL Server on the system, it installed SQL Server 2008; then I installed SQL Server 2008 R2 Express. -- Visual Studio configured itself by default to use the non-R2 server (which I didn't realize was there).
I restored my database into R2, and when I tried to attach it to a VS project, I got the version error. But under Tools / Connect to database, I could switch to the R2 server and connect.
I have an MDF and LDF file of SQL Server 2005. I attached it with SQL Server 2008 and did some change in data. Now when i attached it back to sql server 2005 Express Edition it gives version error. The database 'E: DB JOBPERS.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier.
A downgrade path is not supported. Could not open new database 'E: DB JOBPERS.MDF'.
CREATE DATABASE is aborted. An attempt to attach an auto-named database for file E: DB Jobpers.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Dreamweaver 8 For Dummies Pdf. I know what the problem is, it is quit descriptive error. But was asking the solution of that problem. Anyway thanks to everyone for there reply. Anyone facing same problem, see the tread below and read LEKSS reply hope this will help Update: Quoted external link for safe keeping The database 'ASPNETDB.MDF' cannot be opened because it is version 655.