Solved

microsoft sql supports version 655 and earlier not version 661

Posted on 2014-10-31
4
13 Views
Last Modified: 2016-06-15
Need to add a SQLEXPRESS database from an off site server.
When I attached this database I get the following:
"The database cannot be opend because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported."

Any ideas.
0
Comment
Question by:ryostie
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
LHT_ST earned 500 total points
ID: 40415672
looks like the database is 2008 whereas your trying to add it to a SQLEXPRESS instance which is 2005.

You might need to install a SQLEXPRESS Instance of 2008.
0
 

Author Comment

by:ryostie
ID: 40415747
0
 

Author Comment

by:ryostie
ID: 40419434
LHT ST
I finally had to uninstall all of the SQL Programs and reinstall SQL Server R2
Then SQL Management Studio
Thanks for your insight.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Add a step to a system backup job 6 30
sql query help 15 50
Parse this column 6 34
SQL parsing XML works but want to do it another way 4 16
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question