Problem With Attaching DataBase

Question

HI,
my problem is…i installed version of microsoft sql server 2008 enterprise edition on my pc.. happily am working on that. but, when i am attaching sample data base, its giving the following error.
——————
An exception occurred while executing the T-sql statement or batch.
The database ‘adventureworks’ cannot be opened beacuse it is a version 655.this server support version 654 or earlier. a downgrade path is not supported. could not oened new database ‘Adventureworks2008′
.create database is aborted
———————————————————
I am new to SQL.Can any one pls give the solution.

Answer 1

deinstalling SQL Server and reinstall the latest version will fix the problem. Choose SQLSERVER2008 as Instance-Name while installing and set it in Visual Studio .

---

Do not Forget to Vote as Answer/Helpful, please. It encourages us to help you.

Answer 2

It seems you are attaching SQL serevr 2008 adventureworks DB to sql server 2005 .Make sure you attach it to sql server 2008 u installed are you doing it thru VS..see below link

http://conceptdev.blogspot.in/2009/04/mdf-cannot-be-opened-because-it-is.html

u can  download Adventureworks 2008/2008R2/2012 DB from link

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 3

Hello,

Just as MrTzA post above, please install the latest service pack for SQL Server 2008 from the following link. And then attach the adventureworks database.
http://support.microsoft.com/kb/968382

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support