CODEWITHSUNDEEP
asp.netsql-servervisual-studio
asif
asif

Reputation: 43

asp.net SQL server error

I am getting following error when I run my website on my laptop which i created on another computer

The database 'C:\DOCUMENTS AND SETTINGS\ASIF\DESKTOP\APP\WEBSITE\APP_DATA\DB.MDF' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported. Could not open new database 'C:\DOCUMENTS AND SETTINGS\ASIF\DESKTOP\APP\WEBSITE\APP_DATA\DB.MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database for file C:\Documents and Settings\asif\Desktop\App\Website\App_Data\DB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Please suggest me solution to this.

Regards, Asif Hameed

Upvotes: 0

Views: 201

Answers (2)

mellamokb
mellamokb

Reputation: 56769

Are you trying to use a SQL Server 2008 R2 database in SQL Server 2005? They are not backwards compatible.

See http://forums.asp.net/p/1560835/3859344.aspx and http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/2744a003-d61c-4d3d-93c2-af946e141e7e.

Edit

Also, if you have multiple SQL Server engines installed, make sure connection is pointing to the correct one. It might be an instance name like computername\instance instead of just computername.

Upvotes: 1

Joe Stefanelli
Joe Stefanelli

Reputation: 135729

Version 661 is SQL Server 2008 R2. You are trying to attach a database created with this version to an earlier version of the engine, which is not allowed.

Upvotes: 3

Related Questions