Full text indexing not working!

Hi there,
I recently had to rebuild my database server and recreate databases from bac
kups. All is well except full text indexing is not working although I did in
stall it.
I get the following error from query analyser when trying to access full tex
t indexing:
Server: Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'FULL TEXT INDEX SEARCH' for database ID 184, ta
ble ID 1029578706 with search condition 'as' failed with unknown result (449
ccdc).
In my event view I see error messages:
Unable to initialize project <SQLServer SQL0018400005>. Error: 80040154 - Cl
XXX 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 dat
abase backup does not contain the fulltext catalogs.
http://support.microsoft.com/defaul...kb;en-us;240867
http://support.microsoft.com/defaul...kb;en-us;236789
Matt wrote:

> Hi there,
> I recently had to rebuild my database server and recreate databases from b
ackups. 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 t
ext 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 (4
49ccdc).
> In my event view I see error messages:
> Unable to initialize project <SQLServer SQL0018400005>. Error: 80040154 -
Class not registered .
> Any advice appreciated.