locked
Problem With Attaching DataBase RRS feed

  • 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.
    Sunday, July 7, 2013 7:36 AM

Answers

  • 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.


    • Edited by Murtaza Lokhandwala Sunday, July 7, 2013 8:03 AM Typograhic Mistake
    • Proposed as answer by Fanny Liu Tuesday, July 9, 2013 10:51 AM
    • Marked as answer by Fanny Liu Monday, July 15, 2013 7:56 AM
    Sunday, July 7, 2013 8:02 AM
  • 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

    • Marked as answer by Fanny Liu Monday, July 15, 2013 7:56 AM
    Tuesday, July 9, 2013 10:53 AM

All replies

  • 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.


    • Edited by Murtaza Lokhandwala Sunday, July 7, 2013 8:03 AM Typograhic Mistake
    • Proposed as answer by Fanny Liu Tuesday, July 9, 2013 10:51 AM
    • Marked as answer by Fanny Liu Monday, July 15, 2013 7:56 AM
    Sunday, July 7, 2013 8:02 AM
  • 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

    Sunday, July 7, 2013 8:21 AM
  • 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

    • Marked as answer by Fanny Liu Monday, July 15, 2013 7:56 AM
    Tuesday, July 9, 2013 10:53 AM