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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migrated from Nov 12 '11 at 15:04

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

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

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 – Niranjan Kala Nov 12 '11 at 8:06

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

Your Answer


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.