i have attached a database and getting this error please guide me should i do to resolve it
The database 'C:\USERS\YASIR\DESKTOP\NEW FOLDER\MYWSAT35\APP_DATA\DBMYCMS.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'C:\USERS\YASIR\DESKTOP\NEW FOLDER\MYWSAT35\APP_DATA\DBMYCMS.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Users\Yasir\Desktop\New folder\MyWSAT35\App_Data\dbMyCMS.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
yasir002
Member
68 Points
40 Posts
Database connection error
Jan 27, 2013 04:51 PM|LINK
i have attached a database and getting this error please guide me should i do to resolve it
The database 'C:\USERS\YASIR\DESKTOP\NEW FOLDER\MYWSAT35\APP_DATA\DBMYCMS.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'C:\USERS\YASIR\DESKTOP\NEW FOLDER\MYWSAT35\APP_DATA\DBMYCMS.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Users\Yasir\Desktop\New folder\MyWSAT35\App_Data\dbMyCMS.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Mikesdotnett...
All-Star
154818 Points
19853 Posts
Moderator
MVP
Re: Database connection error
Jan 27, 2013 06:44 PM|LINK
Looks like you need to upgrade your SQL Server Express to at least version 2008.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
oned_gk
All-Star
30955 Points
6336 Posts
Re: Database connection error
Jan 28, 2013 12:57 AM|LINK
your database version is Sql2008, and you want to open coonection using Sql2005sp2 that cause error.
try download and install http://www.microsoft.com/en-us/download/details.aspx?id=30438
wmec
Contributor
6195 Points
3214 Posts
Re: Database connection error
Jan 28, 2013 02:21 AM|LINK
Downgrade from higher version to lower one is not allowed in Sql server.
HuaMin Chen