Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


how to obtain SQL Server FullText Search service?

  • Please log in to reply
1 reply to this topic

#1 BobLewiston


  • Members
  • 69 posts
  • Local time:03:55 AM

Posted 08 March 2009 - 11:24 AM

I did a full installation of SQL Server 2008 Express. Looking at Add / Remove Programs, I see the following pertinent programs installed:
SQL Server 2008
SQL Server 2008 Browser
SQL Server 2008 Management Objects
SQL Server 2008 Native Client
SQL Server 2008 Setup Support File (English)
SQL Server Compact 3.5 SP1 Design Tools English
SQL Server Compact 3.5 English
SQL Server Database Publishing Wizard 1.3
SQL Server VSS Writer
SQL Server System CLR Types

And of course I also have installed .Net Framework 3.5 SP1.

I'm now trying to obtain sample SQL databases. To this end, and by the advice of others, 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

Running services.msc shows the following local services (but not SQL Server FullText Search):
SQL Active Directory Helper Service
SQL Server Browser
SQL Server VSS Writer

Does anyone know how I can obtain the FullText Search service for SQL Server 2008 Express?

BC AdBot (Login to Remove)


#2 Romeo29


    Learning To Bleep

  • Members
  • 3,194 posts
  • Gender:Not Telling
  • Location:
  • Local time:02:55 AM

Posted 09 March 2009 - 11:08 AM

Make sure that you install the version of SQL Server Express with the additional full-text search capabilities.
It appears that you have installed the Compact Version.
This is the larger one of the two downloads possible.

Goto http://www.microsoft.com/express/sql/download/

And download SQL Server 2008 Express with Advanced Services

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users