Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 cannot be opened because it is version 661. This s

Author  Topic 

programer
Posting Yak Master

221 Posts

Posted - 2011-06-05 : 13:21:41
cannot be opened because it is version 661. This server supports version 665
and earlier. A downgrade path is not supported.
Cannot open user default database. login failed.


This is a error.
I think the problem is because the database has been created with SQL 2005

Now I use SQL 2008 R2.

I have no installed SQL 2005




Help me.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-05 : 14:29:49
Are you sure it said '665' and not 655?

Upgrades are always possible (well, except for one odd case), it's downgrades that aren't.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

programer
Posting Yak Master

221 Posts

Posted - 2011-06-05 : 14:38:31
quote:
Originally posted by GilaMonster

Are you sure it said '665' and not 655?

Upgrades are always possible (well, except for one odd case), it's downgrades that aren't.

--
Gail Shaw
SQL Server MVP




My mistake: Is 655

How to upgrade that will worked?
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-05 : 14:52:39
That's not an upgrade.

661 is SQL 2008 R2
655 is SQL 2008.

So you're trying to attach a database created on SQL 2008 R2 to a SQL 2008 server (run SELECT @@version, it'll show that it's 2008, not 2008 R2)
That's attempting to downgrade a database, and databases cannot be downgraded. You can only attach that database to SQL 2008 R2, not any lower version.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -