I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem.
Then I attempted to install AdventureWorks Sample Databases for SQL Server 2008 (SQL2008.AdventureWorks_All_Databases.x86.msi). This attempt failed because SQL Server 2008 Express, basic edition doesnít support Full-text Search, which AdventureWorks requires.
So I uninstalled SQL Server 2008 Express, basic edition and attempted to install SQL Server 2008 Express with Advanced Services (SQLEXPRADV_x86_ENU.exe,version 10.00.1600.22), which does support Full-text Search. This attempt failed because the installer demands an account number and password, which I donít have.
Bear in mind, all Express versions of SQL Server are free from Microsoft, and I obtained my copy directly from Microsoft (http://www.microsoft.com/express/sql/download
Moreover, although during the course of the installation a Product Key window appears, in which a user might have under different circumstances be intended to enter a registration key, in this version of the software this is clearly not intended. I say this because not only is the radio button labeled ďSpecify a free editionĒ selected (with the associated drop-down menu showing ďExpress with Advanced ServicesĒ), and the other associated radio button labeled ďEnter the product keyĒ is left unselected, but also this entire group of WinForm controls is rendered inactive.
Incidentally, I also tried to add Full-text Search capability to my original installation of SQL Server 2008 Express, basic edition via itís Configuration Manager, but the Manager showed (wrongly) that this capability was already installed and was unable to implement this capability.
So: what do I do now?