Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 705
  • Last Modified:

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 :)

0
equentin
Asked:
equentin
  • 2
  • 2
1 Solution
 
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
 
xnmbCommented:
yes, but only if you have admin (local) account to the remote server. you'd have to login to the server remotely
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now