Unable to create a full-text catalog

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Unable to create a full-text catalog

Unable to create a full-text catalog

Rate Topic

Display Mode

Topic Options

Author

Message

bwoodsie

Posted Tuesday, December 11, 2007 4:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 11, 2007 4:43 AM
Points: 1, Visits: 0

Hi,

Hope this is the right forum - apologies if its not. I'm a newbie. I'm at my wits end as I cant create a full-text catalog in SQL server 2000 (v.8.00) Let me explain (I'll try and include as much info as I can):-

When I run the following command:
sp_fulltext_catalog 'Cat_Desc', 'create'

I get the following error mesaage:

Server: Msg 7619, Level 16, State 2, Procedure sp_fulltext_catalog, Line 64
The specified object cannot be found. Specify the name of an existing object.

Trying the create the catalog using the GUI gives me the following error message:
"The specified object cannot be found. Specify the name of an existing object"

I in as user sa. I determine this from running:
select suser_sname()

The SQL Server instance is running under user: LocalSystem
I determine this from 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

The database is owned by: sa (determined by visual inspection).

Yes, full text indexing is enabled for this database as I ran the following command:

EXEC sp_fulltext_database 'enable'

and get the following:
(1 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)

I have a map on the server box to the location where it wants to create the catalog and I can reach this location from the box.

Now I can't think of anything else. I'm at my wits end! Please help. Any comments/suggestions/ideas/diagnostics greatly appreciated.

Thank you,
Al.

PS: Apologies if I'm in the wrong forum!

Post #431697

« Prev Topic | Next Topic »

Permissions