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 1God Look
Ricardo Silva, Jan 13, 2012
|
|
Reply 2I 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 3Hello 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
|