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 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 |
 |
|
|
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? |
|
|
|
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 |
|
|
|
|
|
|
cannot be opened because it is version 661. This s