I'm trying to install SQL2008.AdventureWorks_All_Databases.x86.msi, but whether I try to install "Sample Files" or "Create AdventureWorks DBs", I keep getting the following error:

PrepInstance() failed for MSSQL$SQLEXPRESS.
The following features are missing: Full Text Search

I already have installed on my PC:
Microsoft SQL Server 2008
Microsoft SQL Server 2008 Browser
Microsoft SQL Server 2008 Management Objects
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Setup Support File (English)
Microsoft SQL Server Compact 3.5 SP1 Design Tools English
Microsoft SQL Server Compact 3.5 English
Microsoft SQL Server Database Publishing Wizard 1.3
Microsoft SQL Server VSS Writer

Any suggestions?

I remember with SQL Server 2005 Express, Microsoft had a separate install package that did not include the Full-Text support. You may want to check for a SQL Server 2008 package that includes Full-Text services. You can double check to make sure Full Text is installed by going to Start -> Run and type "services.msc" and find this service "SQL Server FullText Search." This will tell you if it is installed or not.

Hope this helps,
GM

Geek-Master:

services.msc shows:

SQL Active Directory Helper Service
SQL Server (SQLEXPRESS)
SQL Server Agent (SQLEXPRESS)
SQL Server Browser
SQL Server VSS Writer

but not SQL Server FullText Search. Do you (or does anyone else) know how I can obtain the FullText Search service?

Thread a bit old, but this will be usefull for others who see it.
SQL Server 2008 Express edition does not have Full Text Index service, the solution is downloading the Advanced Services version.
http://www.microsoft.com/downloads/d...displaylang=en
The size is far bigger from the standard edition, but it includes some nice features.