• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 795
  • Last Modified:

Full-Text Indexing - Retrospective Install

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?
0
Carl Tawn
Asked:
Carl Tawn
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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:

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic25572.aspx

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
0
 
Carl TawnSystems and Integration DeveloperAuthor Commented:
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now