Impossible to attach Adventureworks

• Ghoezayma

  SSC Veteran

  Points: 243

  More actions

  October 31, 2007 at 5:23 am

  #747001

  Hi,

  It is definitely the 2005 version of the database...installed it from the 2005 installation cd.

  Kind regards

  Ghoezayma

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  October 31, 2007 at 5:40 am

  #747005

  While installing SQL Server 2005, you may select option for samples & databases, at that time sample databases installed.

  

• Mark Simmerman

  Old Hand

  Points: 381

  More actions

  November 10, 2007 at 1:39 pm

  #750063

  What I have found that I received this error when I chose to install the default instance option for SQL 2005 over a previous SQL 2000 installation. This error seems to be due to trying to attach a 2005 formatted database to a 2000 based instance. When I upgraded the instance, then the AdventureWorks database attached fine.

  For what it's worth...

  Mark Simmerman

  Napa, California

• Ghoezayma

  SSC Veteran

  Points: 243

  More actions

  November 12, 2007 at 6:31 am

  #750222

  Thanx for all the help It is much appreciated.

  I did choose the default instance option for sql 2005...

  What I actually wanted was for both instances to co-exist happily since I need to use both 2000 and 2005. I have found a workaround for now...using virtual pc for my 2005 adventureworks exercises.

  Kind regards

  Ghoezayma

  (Cape Town, South Africa)