Member Avatar for BobLewiston

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?

  • 3 Contributors
  • 3 Replies
  • 197 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by Gustavo MPO
Member Avatar for Geek-Master

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

Member Avatar for BobLewiston

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.