Dofactory.com
Dofactory.com
 Back to list
Views:   13.4K
Replies:  3
Archived

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

Adam Rice, Nov 27, 2011
Reply 1
God Look
Ricardo Silva, Jan 13, 2012
Reply 2
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.
Alex B, Jan 11, 2012
Reply 3
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.
Dan McMillan, Dec 01, 2011
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.