Full text indexing not working!

Hi there,
I recently had to rebuild my database server and recreate databases from backups. All is well except full text indexing is not working although I did install it.
I get the following error from query analyser when trying to access full text indexing:
Server: Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'FULL TEXT INDEX SEARCH' for database ID 184, table ID 1029578706 with search condition 'as' failed with unknown result (449ccdc).
In my event view I see error messages:
Unable to initialize project <SQLServer SQL0018400005>. Error: 80040154 - Class not registered .
Any advice appreciated.
Matt,
Can you pass us the exact sql query?Were you trying to search for 'as'? If
so, isnt that included in the ignored words list?Also, whats the SQLServer
version and service pack level?
I apologise for replying back with another set of questions but little more
detail would help !
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Matt" <matt@.community.nospam> wrote in message
news:3FF82A86-0B99-490C-AB5F-17E6A6A4E8F0@.microsoft.com...
> Hi there,
> I recently had to rebuild my database server and recreate databases from
backups. All is well except full text indexing is not working although I did
install it.
> I get the following error from query analyser when trying to access full
text indexing:
> Server: Msg 7607, Level 17, State 1, Line 1
> Search on full-text catalog 'FULL TEXT INDEX SEARCH' for database ID 184,
table ID 1029578706 with search condition 'as' failed with unknown result
(449ccdc).
> In my event view I see error messages:
> Unable to initialize project <SQLServer SQL0018400005>. Error: 80040154 -
Class not registered .
> Any advice appreciated.
|||Hi,
Are you using SQL 2000.
If yes, then install SP3 for SQL Server 2000. I had a identical problem
after database restore some time back and got resolved after applying SP3.
Note:
Even if you have SP3 , try to reinstall and check the FULLTEXT searrh.
Thanks
Hari
MCDBA
"Matt" <matt@.community.nospam> wrote in message
news:3FF82A86-0B99-490C-AB5F-17E6A6A4E8F0@.microsoft.com...
> Hi there,
> I recently had to rebuild my database server and recreate databases from
backups. All is well except full text indexing is not working although I did
install it.
> I get the following error from query analyser when trying to access full
text indexing:
> Server: Msg 7607, Level 17, State 1, Line 1
> Search on full-text catalog 'FULL TEXT INDEX SEARCH' for database ID 184,
table ID 1029578706 with search condition 'as' failed with unknown result
(449ccdc).
> In my event view I see error messages:
> Unable to initialize project <SQLServer SQL0018400005>. Error: 80040154 -
Class not registered .
> Any advice appreciated.
|||i think you'll need to recreate and repopulate the fulltext catalogs. a database backup does not contain the fulltext catalogs.
http://support.microsoft.com/default...b;en-us;240867
http://support.microsoft.com/default...b;en-us;236789
Matt wrote:

> Hi there,
> I recently had to rebuild my database server and recreate databases from backups. All is well except full text indexing is not working although I did install it.
> I get the following error from query analyser when trying to access full text indexing:
> Server: Msg 7607, Level 17, State 1, Line 1
> Search on full-text catalog 'FULL TEXT INDEX SEARCH' for database ID 184, table ID 1029578706 with search condition 'as' failed with unknown result (449ccdc).
> In my event view I see error messages:
> Unable to initialize project <SQLServer SQL0018400005>. Error: 80040154 - Class not registered .
> Any advice appreciated.
|||Hi and thanks for the replies;
It is SQL 7.0 with service pack 4. I am unsure whether I installed full text search AFTER applying the service pack 4 or not.
My example used an ignore word but other keywords fail as well (usually sql will tell you if it is an ignored word).
I have already rebuilt and repopulated the catelogues but still have the problem.
Should I reinstall full text search and if so how do I uninstall a Full text search and then reinstall? OR should I reinstall Service pack 4.
thanks again,
Matt