Full-Text Indexing - Retrospective Install

Posted on 2009-04-24
Last Modified: 2012-05-06
Hi Folks,

I have recently had to install full-text indexing on an existing SQL 2005 box (Workgroup Edition with SP2).

The installation went fine, the service is running and the server has been rebooted. However, if i try to create a catalog i get the message "Full-text indexing is not installed, or a required component cannot be loaded". The "Use Full-Text Indexing" option on the Files tab of the Database properties is also disabled.

Any ideas what i'm missing and how I can get this working?
Question by:Carl Tawn
    LVL 57

    Expert Comment

    by:Raja Jegan R
    If you install Full Text Index after applying any Service Packs, then you have to reinstall that Service Packs to make Full Text Indexes work:

    For SQL Server 2005 default instance,
       HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\GlobalAdminBlob

    Is there a key named Blob0?
    The key indicates the Full Text Search
    LVL 52

    Accepted Solution

    Thank for your reply. Re-installing SP2 was going to be the next step, but it turns out that the muppet in charge of the DB server "forgot" to do the reboot. Once he actually did do it Full-text started working correctly.

    Thanks anyway.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now