Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am doing some full text stuff in a database and keep getting this error message back. Full-Text Search is not installed, or a full-text component cannot be loaded. The full text search is installed and the service is running. I have also run a query in the db to see if it is installed and it say 0 (no). I am using sql server 2005 and windows server 2003. Any help would be greatly appreciated.


Hi I gone and done that and can not see the reg value so I wlll have a crack at install it now.

share|improve this question

1 Answer 1

Try executing this query.

select fulltextserviceproperty('isfulltextinstalled')

If SQL returning a 0 means the service is not installed.

or

Could you please check the following registry path 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

If not installed, stop all currently installed services and try to reinstall fulltext seratch.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.