Sql-server – SQL Full Text Not Installed

sql server

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.

Best Answer

Try executing this query.

select fulltextserviceproperty('isfulltextinstalled')

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

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.

Related Solutions

Sql-server – How to detect if full text search is installed in SQL Server

I like SELECT over PRINT

So here is my take on this

SELECT 
    CASE 
         WHEN 
             FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 
         THEN 
              'INSTALLED' 
         ELSE 
              'NOT INSTALLED' 
    END IsFullTextInstalled

Sql-server – SQL 2005 Database Not Accessible

Most likely it's a permissions problem on the new server. Your SQL logins don't carry over automatically and if you manually create it on the new server it'll get a different SID which won't jive with the one that's granted access to the database.

Best way is to use sp_help_revlogin (KB918992 in case the link ever dies) to generate a script of the logins on the old server and then run the script on the new server. This procedure will carry over SID and password information to the new server effectively recreating the login on the new server. Once this is done the permissions set up in your database should then be in sync with the login(s) on the new server.

This shouldn't be a problem for Windows logins as SQL gets the SID from Windows, although you'll still need to set up the Windows login on the new server. sp_help_revlogin will handle this part for you as well.

Best Answer

Related Solutions

Sql-server – How to detect if full text search is installed in SQL Server

Sql-server – SQL 2005 Database Not Accessible

Related Topic