Solved

Problem setting up Full Text Search Catalog

Posted on 2003-12-05
6
695 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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.

820 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