Unable to "enable" full text catalog creation - please hel..

Hi,

Hope u can help me with this one. I'm running SQL Server 2000.

I try to build a full text catalog by running:

sp_fulltext_catalog 'Cat_Desc', 'create'

but I get the following error message:
Server: Msg 15601, Level 16, State 1, Procedure sp_fulltext_catalog,
Line 17
Full-Text Search is not enabled for the current database. Use
sp_fulltext_database to enable Full-Text Search.

so I try to enable it by running the following command:

EXEC sp_fulltext_database 'enable'

but I get the following error message:

(1 row(s) affected)
(0 row(s) affected)
Server: Msg 7619, Level 16, State 2, Procedure sp_fulltext_database,
Line 61
The specified object cannot be found. Specify the name of an existing
object.

Yes, full text indexing is installed. I run the following command:

SELECT fulltextserviceproperty('IsFulltextInstalled')

and get the following as a result:
1

More Details:

1. SQL Server Version = Microsoft SQL Server 2000 - 8.00.194 (Intel
X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft
Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service
Pack 4)

2. Server = MS Windows 2000 5.00.2195 Severice Pack 4

3. DB Owner = sa

4. I'm in as user: dbo. I determine this by running: SELECT
USER_NAME()

5. DB is runnign under user: LocalSystem. I determine this by running
the following command:
DECLARE @serviceaccount varchar(100)
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE',
N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
N'ObjectName',
@ServiceAccount OUTPUT,
N'no_output'
SELECT @Serviceaccount



Any suggestions/comments/ideas much appreciated...
Thanks,
Al.

can you try this;

sp_fulltext_service 'clean_up'

And then try again?

Is there any relevant history here? Did you restore this database from
another server?

On Jan 24, 10:21 am, "almu...@altavista.com"
wrote:
> Hi,
>
>         Hope u can help me with this one. I'm running SQL Server 2000.
>
> I try to build a full text catalog by running:
>
> sp_fulltext_catalog 'Cat_Desc', 'create'
>
> but I get the following error message:
> Server: Msg 15601, Level 16, State 1, Procedure sp_fulltext_catalog,
> Line 17
> Full-Text Search is not enabled for the current database. Use
> sp_fulltext_database to enable Full-Text Search.
>
> so I try to enable it by running the following command:
>
> EXEC sp_fulltext_database 'enable'
>
> but I get the following error message:
>
> (1 row(s) affected)
> (0 row(s) affected)
> Server: Msg 7619, Level 16, State 2, Procedure sp_fulltext_database,
> Line 61
> The specified object cannot be found. Specify the name of an existing
> object.
>
> Yes, full text indexing is installed. I run the following command:
>
> SELECT fulltextserviceproperty('IsFulltextInstalled')
>
> and get the following as a result:
> 1
>
> More Details:
>
> 1. SQL Server Version = Microsoft SQL Server  2000 - 8.00.194 (Intel
> X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft
> Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service
> Pack 4)
>
> 2. Server = MS Windows 2000 5.00.2195 Severice Pack 4
>
> 3. DB Owner = sa
>
> 4. I'm in as user: dbo. I determine this by running: SELECT
> USER_NAME()
>
> 5. DB is runnign under user: LocalSystem. I determine this by running
> the following command:
> DECLARE @serviceaccount varchar(100)
> EXECUTE master.dbo.xp_instance_regread
> N'HKEY_LOCAL_MACHINE',
> N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
> N'ObjectName',
> @ServiceAccount OUTPUT,
> N'no_output'
> SELECT @Serviceaccount
>
> Any suggestions/comments/ideas much appreciated...
> Thanks,
> Al.