Solved

Problem setting up Full Text Search Catalog

Posted on 2003-12-05
6
697 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

630 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