Problem setting up Full Text Search Catalog

hi guys,

i'm trying to set up a full text search catalog on MS SQL2K and i am not getting very far. i've succeeded on our local development server but cannot get the catalog created on the remote server.

i'm doing the following connecting through query analyser:

EXEC sp_fulltext_database @action='Enable'
EXEC sp_fulltext_catalog @ftcat = 'CobhamFullText', @action='CREATE'

but this is where it falls over with the following message:

Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_catalog, Line 65
Execution of a full-text operation failed. The directory name is invalid.

as i say, this works fine on my local server and i can continue and create indexed and search merrily. remotely we have SQL installed on the C: drive and the data sits on D: - i have tried adding @path to the sproc but still no good.

any ideas? i'm sure it's a simple thing but it's doing my head in!

thanks :)

equentinAsked:
Who is Participating?
 
xnmbCommented:
yes, but only if you have admin (local) account to the remote server. you'd have to login to the server remotely
0
 
xnmbCommented:
have you ensured that the account used by mssearch service on the remote server has permissions to the directory?
0
 
equentinAuthor Commented:
i think so ... how can i find out? i've connected to the database remotely using an administrator account and as far as i can tell the D:\Microsoft SQL Server\MSSQL\FTDATA folder has full permissions for this user.
0
 
equentinAuthor Commented:
ok, slight change in the problem - just discovered that our remote installation of SQL doesn't actually have MS search service installed!!!

is there a way i can install it / start it without messing up the current SQL set up and configuration?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.