Home  /  Questions  /  Question



50   50
Nov 27, 2011


Solution and newer versions of SQL Server??

I am unable to get the solution to successfully access any of the databases.

When attempting to connect to the database the following error occurs:

The database 'C:\USERS\XXXXXX\DOCUMENTS\DOFACTORY PATTERNS 4.0 CS\PATTERNS IN ACTION\HOST.WCF.ACTIONSERVER\APP_DATA\ACTION.MDF' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.

Could not open new database 'C:\USERS\XXXXXX\DOCUMENTS\DOFACTORY PATTERNS 4.0 CS\PATTERNS IN ACTION\HOST.WCF.ACTIONSERVER\APP_DATA\ACTION.MDF'. CREATE DATABASE is aborted.

An attempt to attach an auto-named database for file C:\Users\XXXXXX\Documents\DoFactory Patterns 4.0 CS\Patterns In Action\Host.WCF.ActionServer\App_Data\Action.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Can anyone provide guidance on this error.  It looks like there is a database version mismatch.

I have both SQL Server 2005 and 2008 installed on my PC.

Please help.

Adam




830   99.9
Dec 01, 2011
Hello Joseph:

The answer lies in this part of the error message: cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.

You are running an older version of SQL Server than the database itself.
Upgrade to the most recent version / SP of SQL Server and that should take care of this error.

Hope this helps.
Dan.
 2 comments
 
Thanks. Adam --- Adam Rice  Dec 05, 2011
 
I got the same problem but I have SQLEXPRESS 2008R2. It happens that when I installed Sqlexpress I created another instance and I used Server Explorer to attached the Action.mdf to this new instance and I get access in the explorer. To make the application work, I changed the web.config to use this instance name instead of sqlexpress. ---Alex B. --- Alex B  Jan 11, 2012

60   95.3
Jan 11, 2012
I have the same issues today Jan 11, and I finally made the Web Forms App worked. What I did were to use IIS Express and another instance of 2008 R2 SQL Express. I changed the SQLEXPRESS name in the config to this server instance. I added a connection string for the aspnetdb with the sql server instance, and replaced the LocalSqlServer name in the config file. Refer to p18 of the Action doc.

50   50
Jan 13, 2012
God Look