Re: Full text HELP!!!

From: Hilary Cotter (hilaryk_at_att.net)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 12:46:16 -0400

this basically means that MSSearch is unable to access SQL Server to
retrieve the rows it wishes to index.

Most frequently this problem is caused when you modify the MSSQL Server
account using control panel instead of Enterprise Manager. Check out this kb
article for more info:

http://support.microsoft.com/default.aspx?scid=kb;en-us;277549

This is SQL 7 but it still applies 

-- 
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
":)" <anonymous@discussions.microsoft.com> wrote in message
news:2dbfa01c46a87$29eca3c0$a501280a@phx.gbl...
> Can anyone tell me why this doesnt work:
>
> 1- full text service is running under local system account
> 2- sql server is running under a domain account
> 3- local admin consists of both (domain admins and system)
> 4- correct priviledges are given to the folders (sql
> folders)
> 5- sql is in CLUSTER (4 nodes / 4 virtual servers)
>
> When i create a catalog it works. When i populate it.. it
> says that it populated with sucess but value maintains 0 ??
>
> I have the article (microsoft) where it tells me builtin
> admins need to be in the logins.. i have tryed with
> builtin admin AND nt authority system (seperatly) and
> still doesnt work... it worked ONCE but then never worked
> again.. it populates with no errors but the value mantains
> 0
>
> event viewer gives me the following warnings: 3036 3035
> and 3024 but when i reaseached them i get the article
> about the builtin admins and ms search running under local
> system acount which is already the case...
>
> Can anyone help me? Is full text supported in cluster????
> what can i do to fix this problem?

Relevant Pages

  • Re: SQL Server Issues ::: ( how to avoid this issues )
    ... and I can sure *not* login to my SQL Server! ... > DAT files, it wont work unless u supply the exact parameters... ... > database security, the traderes will be really into deep truble... ... >>> You *cannot* keep your domain admins out of SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: users require SQL admin but not server admin ?
    ... server role in SQL Server, without making them a part of local admins group ... on the box, or domain admins. ... Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.server)
  • Full text HELP!!!
    ... 1- full text service is running under local system account ... 2- sql server is running under a domain account ... admins need to be in the logins.. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Server Issues ::: ( how to avoid this issues )
    ... most of the SQL Server mid-ranged clients are Trading companies... ... database security, the traderes will be really into deep truble... ... DAT files, it wont work unless u supply the exact parameters... ... >> admins, then consider encrypting it before it's put into the database, ...
    (microsoft.public.sqlserver.server)
  • Re: FTI, Searching and other Filters
    ... No matter what I specify for a search condition, ... "SQL SERVER DBA"') ... Remove the FTI from the table. ... Add an OfficeID column to the table and populate it. ...
    (microsoft.public.sqlserver.fulltext)