Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Nov 2008
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to obtain SQL Server FullText Search service?

    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 (SQLEXPRESS)
    SQL Server Agent (SQLEXPRESS)
    SQL Server Browser
    SQL Server VSS Writer

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

  • #2
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You have to install SQL Server 2008 Express Edition with advanced Features.
    http://www.microsoft.com/downloads/d...0-1311d670e336

    Enjoy


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •