Computing.Net > Forums > Database > SQL2000 Job Problems

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

SQL2000 Job Problems

Reply to Message Icon

Name: techieman
Date: June 19, 2007 at 09:24:35 Pacific
OS: Server 2003
CPU/Ram: 3.06GHz / 2.00GB
Product: HP
Comment:

We have various SQL Jobs that run everyday to undertake various tasks.

The job in question is this "full-text full population for full-text catalog CPFullText in database CPTest"
(full text indexing I guess, as I didnt set any of these up!)

This has been running fine up until last week but is now presenting the following error message.

CP Full Text

Executed as user: XX-XXX\service-admin. Full-Text Search is not installed, or a full-text component cannot be loaded. [SQLSTATE 42000] (Error 7609). The step failed.

Now, I can see the obvious reason is that the Full Text Search Feature needs to be installed. However, this has been working fine up until now.

Does anyone have any ideas as to why this might have stopped working?

Any help much appreciated.



Sponsored Link
Ads by Google

Response Number 1
Name: jqp
Date: July 19, 2007 at 17:10:15 Pacific
Reply:

Possibly a permissions issue for the service-admin ID, bet the security was changed in some way

full text search requires some very specific permissions and security changes can cause it to fail - very common problem

ASUS M2NPV-VM <> Samsung 22"


0
Reply to Message Icon

Related Posts

See More


Product Stability access date query



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: SQL2000 Job Problems

problem with sql server 2000 DSN www.computing.net/answers/dbase/problem-with-sql-server-2000-dsn/380.html

automatically fill related fields www.computing.net/answers/dbase/automatically-fill-related-fields/227.html

sql syntax problem www.computing.net/answers/dbase/sql-syntax-problem/291.html