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.
| 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 665and 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 2005Now I use SQL 2008 R2.I have no installed SQL 2005Help 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 ShawSQL Server MVP |
 |
|
|
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 ShawSQL Server MVP
My mistake: Is 655How to upgrade that will worked? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-05 : 14:52:39
|
| That's not an upgrade.661 is SQL 2008 R2655 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 ShawSQL Server MVP |
|
|
|
|
|
|
cannot be opened because it is version 661. This s