Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have the following error

The database 'Test' cannot be opened because it is version 661. This server supports versions 655 and earlier. A downgrade path is not supported.

Usually this kind of error occurs when the database was made with SQL Server 2008 R2 and is opened with for example SQL Server 2008 SP2, but the problem is that I'm trying to open it exactly in SQL Server 2008 R2 which supports version 661. So what's the problem?

share|improve this question
add comment

migrated from stackoverflow.com Nov 12 '11 at 15:04

This question came from our site for professional and enthusiast programmers.

4 Answers

up vote 5 down vote accepted

You are connected to a SQL Server 2008 instance. The error message clearly indicates that. See How to determine the version and edition of SQL Server and its components, the section on SQL Server Database Engine version lists no less than 4 methods:

  • Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.
  • Method 2: Look at the first few lines of the Errorlog file for that instance.
  • Method 3: Connect to the instance of SQL Server, and then run the following query:

    Select @@version;

  • Method 4: Connect to the instance of SQL Server, and then run the following query:

    SELECT SERVERPROPERTY('productversion'),
    SERVERPROPERTY ('productlevel'),
    SERVERPROPERTY ('edition');

share|improve this answer
add comment

Are you missing a Service Pack for 2008 R2?

share|improve this answer
    
how can I check that? –  Sergey Nov 12 '11 at 6:09
    
@Sergey: Easiest way possible? Run Windows Update and see if there is a SP for SQL Server listed. Otherwsise run Select @@version from the SQL prompt. –  Gabriel Magana Nov 12 '11 at 6:13
    
If you go the Select @@version way, make sure the new DB is at least the same version or newer than the old. –  Gabriel Magana Nov 12 '11 at 6:16
    
Check everything in details over here support.microsoft.com/kb/321185 –  Niranjan Kala Nov 12 '11 at 8:06
add comment

Actually, this gets even stranger. I was getting your same error message.

Turns out, I had SQL Server 2008 RTM - no service packs, no "R2". I updated to SQL Server 2008 SP2 (still not "R2").

I tried connecting to the same database. Now I get the following message:

AdventureWorksLT2008 cannot be opened because it is version 661. This server supports 662 and earlier A downgrade path is not supported ...

So you lose if your server is lower than "661", and you lose if your server is greater than "662"?

share|improve this answer
    
So, does it mean that you will only win if your server is 661 or 662. Any number that is not 661 or 662 you will definitely lose. What a ""Great"" product! –  Jack Jan 4 '13 at 5:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.