Solved

Problem setting up Full Text Search Catalog

Posted on 2003-12-05
6
691 Views
Last Modified: 2008-01-09
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
Comment
Question by:equentin
  • 2
  • 2
6 Comments
 
LVL 5

Expert Comment

by:xnmb
ID: 9887867
have you ensured that the account used by mssearch service on the remote server has permissions to the directory?
0
 

Author Comment

by:equentin
ID: 9895391
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
 

Author Comment

by:equentin
ID: 9895669
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
 
LVL 5

Accepted Solution

by:
xnmb earned 250 total points
ID: 9895701
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now