equentin
asked on
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 :)
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 :)
have you ensured that the account used by mssearch service on the remote server has permissions to the directory?
ASKER
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.
ASKER
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?
is there a way i can install it / start it without messing up the current SQL set up and configuration?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.