Unable to create full text catalog! Please help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Unable to create full text catalog! Please help

Author

Topic

jellybean
Starting Member

15 Posts

Posted - 2007-12-10 : 12:04:13

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. 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.

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)

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!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-10 : 23:18:25

Tried that with gui in em?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-11 : 04:14:03

Do you have rights to the default directory the catalog would be created on?

jellybean
Starting Member

15 Posts

Posted - 2007-12-11 : 05:05:08

quote:
Originally posted by rmiao

Tried that with gui in em?

Yeah, sure. I get the error message: "The specified objetc cannot be found. Specifify the name of an existing object"

jellybean
Starting Member

15 Posts

Posted - 2007-12-11 : 05:28:14

quote:
Originally posted by RickD

Do you have rights to the default directory the catalog would be created on?

Unsure. I'm unsure as I don't know how to determine this. Its point to a path on my "f" drive. This is certainly mapped and I can browse to the directory. How can I determine I have the correct rights to the default directory the catalog would be created on?
Any help much appreciated.
Jelly

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-11 : 23:31:31

Do you have proper permission?

jellybean
Starting Member

15 Posts

Posted - 2007-12-12 : 07:04:30

Thanks rmiao but how do I determine that I have the proper permission?

Confused,
jelly

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-12 : 07:36:50

If you are using sa, check that the Service account has access to this directory and can write to it.

jellybean
Starting Member

15 Posts

Posted - 2007-12-12 : 09:26:10

Thanks RickD for the advice but I'm sorry how do you do this? I'm kind of new to SQL Server. Any advice/guidance much appreciated. Sorry for being such a drag!

Jelly
The stupid one.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-12 : 23:51:01

Do you have dba in your company? Work with them.

jellybean
Starting Member

15 Posts

Posted - 2007-12-13 : 06:37:50

Unfortunately no, our new boss had a...shall we say a differing of professional opinion and he walked. I wish there was a place online where you could go to talk to a dedicated DBA. I guess I'll have to stick to forums etc...
Thanks for all your suggestions though rmiao. Cheers.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-13 : 07:29:24

Check in Services which account the SQL Server runs under (hopefully yopu have the password for this),m log on as this user and see if you can write to the directory using this user. If not, ask your network security people to add the access.

jellybean
Starting Member

15 Posts

Posted - 2007-12-13 : 09:59:30

Thanks RickD, I've had a look in Service as I see that the "SLQSERVERAGENT" runs under a user called "COMPANYNAME\ab_admin" (and yes I've have the password) I've checked his account in the "Security" tab in SQL Server 2000 and see his account name is just called: "ab_admin" and is of type "standard".
Anyway the permissions of "ab_admin" look sufficient at:
Server Role is set to: System Administrator
Database Access is set to: public and db_owner

I have logged in as this user and in an effort to see if this user can access the path where the full text catalog is kept. To do that I have run the following command from inside Query Analyser:

EXEC master..xp_cmdshell 'dir f:\NME_SQL_DAT\MSSQL\FTDATA\'

This command displayed the contents of the directory indicated, but thats just a read not a write to it. I'm afraid I'm not sure how to do check to see if this user can write to the directory. Any ideas?

Jelly.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-13 : 11:04:07

Log into the machine as this user and then see if you can write to the directory. This is nothing to do with SQL Server, this is network permissions.

jellybean
Starting Member

15 Posts

Posted - 2007-12-13 : 12:21:14

Hi RickD, ahh I understand u now, thanks man. I can login on the box using this user and create a new file at this path. I can also edit a file at this path and the changes are accepted so, unfortunately, I don't think its a permissions thing. Damn! I thought that was going to be it. Thanks for the suggestion though. Any more avenues of thought that I can pursue? Any ideas mate?

Jelly.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-14 : 03:29:35

quote:

The SQL Server instance is running under user: LocalSystem

Sorry, I just noticed this part of your post. If the SQL Service is running under LocalSystem, you might not have permissions at this level rather than the agent level. Try changing this to a Domain user with permissions and see if that works.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-15 : 01:13:36

Did you logon sql server with sa?

jellybean
Starting Member

15 Posts

Posted - 2007-12-18 : 11:27:04

quote:
Originally posted by RickD

quote:

The SQL Server instance is running under user: LocalSystem

Sorry, I just noticed this part of your post. If the SQL Service is running under LocalSystem, you might not have permissions at this level rather than the agent level. Try changing this to a Domain user with permissions and see if that works.

Sorry for the delay.
I don't think you should. According to the article located at:
http://www.fogcreek.com/FogBugz/KB/dbsetup/FullTextSearch.html

under the section entitled "Setting the Startup Service Account" - "...SQL server has to start and run under the System account..."

What do you think?
Jelly.

jellybean
Starting Member

15 Posts

Posted - 2007-12-18 : 11:29:37

quote:
Originally posted by rmiao

Did you logon sql server with sa?

Sorry for the delay.
Yes, I did rmiao. And 1 or 2 others but still no joy.

Confused,
Jelly

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-18 : 21:00:06

Ok, what's sql2k sp level on the server? Tried reinstall full text index then reapply sp?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources