Setup Problem (SQL2008.AdventureWorks_OLTP_DB_v2008.x86.msi)


[Moved from http://www.codeplex.com/SqlServerSamples/]
There's a problem with this package, I'll try to explain below.
If you directly install the database files and samples at the first time you start this setup package then no problem.
However, the problem occurs of you repeat the following steps:
  • Run this installation file and install only Samples and Program Menu Shortcuts but no database files (Restore AdventureWorks DBs).
  • After finishing the above installation, rerun this setup then Change, repair, or remove installation window appears. Click Change button.
  • In the Custom Setup window, choose Restore AdventureWorks DBs and underneath to install then click Next button.
  • Database Setup window appears. The problem occurs just in this window. There is a combobox below to choose the SQL Server Instance to install this sample database files. However, SQL Server Instances are not listed in it! If you chose to install database files at the first time when we installed the Samples and Program Menu Shortcuts then we would see the installed SQL Server Instances in this combobox. But if you want to install database files another time by repeating the above steps, then you end up with an empty combobox.
    Ekrem Önsoy [enaksanamun]


icheung wrote Oct 15, 2008 at 6:57 PM

The workaround is to click 'Remove' button and then open up the msi file to install again. But make sure you have selected to restore the AdventureWorks DB this time.