Last post Jan 31, 2011 05:09 AM by cbhcmc
May 22, 2010 04:56 AM|Ruthless23|LINK
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.
May 22, 2010 01:47 PM|Careed|LINK
As I understand it, it sounds like you are trying to use a SQL Server 2008 R2 database in SQL Server 2008, which are not backwards compatible.
When you say that you can open SQL Server 2008 Management Studio Express, could this be actually the version for R2? Did you install or upgrade R2?
In SSMS, when you connect to a database, look at the Object Explorer and identify the version associated with that particular instance. If it starts with "10.5...", then it's an R2 DB.
Jan 31, 2011 05:09 AM|cbhcmc|LINK
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.