Can't enable Full Text on database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Got a strange problem.

Had a SQL 7.0 Box with FTS on a database. Worked fine except for one quirk
we never tracked down. Starting up the MSSearch Service would fail 1/2 the
time due to timeout. Other 1/2 would take a long time (like sometimes an
hour) to start.

Upgraded to SQL 2000, no SP.
Upgrade went fine, similar startup problems.

Applied SP4.

Got the usual warning about having to recreate indices, etc. Not a problem
since we were releasing new code specifically for SQL 2000 FT.

Now... well it just doesn't work.

For example, if I try to start an index build on a table, I get Error 15601:
Full-Text Search is not enabled for the current database...

Ok, no problem.. try

sp_fulltext_database 'enable'

get

Server: Msg 7635, Level 16, State 1, Procedure sp_fulltext_database, Line 46
The Microsoft Search service cannot be administered under the present user
account

First thought was try to synchronize the passwords (i.e. start/stop SQL
Server, change to local account and then back to the domain account so that
MSSearch can talk to it.)

No Joy.

So, at this point I'm either facing calling Microsoft, or taking the server
offline for a day while I uninstall SQL 2000, reinstall it and re-attach the
databases and hope that works.

Suggestions?




--
--
Greg D. Moore
President Green Mountain Software
Personal: http://stratton.greenms.com
SQL Server Consulting sql at greenms.com


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem connecting to SQL2000...
    ... problems with their current sql installation. ... >Install without database engine (that way you could ... >account is the database access account. ... >Microsoft MVP - SharePoint Portal Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: ASP.NET, Win2k, SQL 2k on an intranet (w/Kerberos?)
    ... In your place I would go trough database and have mirrored accounts in SQL ... you can create views on SQL server to filter out ... Grant ASPNET account logon rights to SQL server and limit ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)