Re: Sharepoint index problems in SQL Server.

From: Jéjé (willgart_at__A_hAotmail_A_.com)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 08:06:53 -0500

It's a SBS 2003 system

The Administrator account is a sysadmin and have all the access to all the
database.
I don't see any login error in the event log
It's not a cluster, it's a simple server.

thanks for the KB articles, but I can't found any documentation about my
C000005 error and I've no other errors code.

I'll reapply the SP3 today.

"John Kane" <jt-kane@comcast.net> a écrit dans le message de
news:Ow4kVXNAEHA.580@TK2MSFTNGP11.phx.gbl...
> Jéjé,
> Ok. There are several reasons for FT Indexing problems, and the below are
> usually the first to review. There are additional issues that can affect
FT
> Indexing. Does the BUILTIN\Administrator logon exist on this problem
server?
> If so, does it have all the default permission (sysadmin) and the default
> database is master and language US_English? If it does not exist, can you
> re-add it with these default permission. Also, is this a clustered
> (Passive/Active or Active/Active) environment? Below are a few KB
articles,
> that you should review as well what is the full output of the following
SQL
> code:
>
> select @@version
> select @@language
>
> 317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate
Catalogs
> [800705b4 timeout]
> http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
>
> 263712 (Q263712) INF: How to Impede Windows NT Administrators from
> Administering a Clustered SQL Server
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;263712
> (BUILTIN\Administrators)
> 814035 (Q814035) FIX: A Full-Text Population Fails After You Apply SQL
> Server 2000 Service Pack 3
> http://support.microsoft.com/default.aspx?scid=kb;en-us;814035 (80004002 -
> No such interface supported)
>
> 817301 PRB: Microsoft Search Full-Text Catalog Population Fails When You
> Upgrade SQL2K Failover Cluster to SQL2K SP3
> http://support.microsoft.com/default.aspx?scid=kb;en-us;817301
>
> Regards,
>
> John
>
>
>
>
> "Jéjé" <willgart@_A_hAotmail_A_.com> wrote in message
> news:uAONWFNAEHA.2212@TK2MSFTNGP10.phx.gbl...
> > Well
> >
> > I've set back the account localsystem for both SQL Server and Microsoft
> > Search.
> > I've rebuild the catalogs, but there is no more results.
> > All my documents are not returned by a search request.
> >
> > My Application warning event is generated by Microsoft Search service
> > event id 3035
> >
> > Also I've this warning only when I start a full process of the catalog
> >
> > And I've no hard drive space problem (more then 30gb available)
> >
> >
> >
> > "John Kane" <jt-kane@comcast.net> a écrit dans le message de
> > news:er9VHrLAEHA.1700@TK2MSFTNGP12.phx.gbl...
> > > Jéjé,
> > > Could you search the Application event log for other "Microsoft
Search"
> or
> > > MssCi source events (warnings & errors) near the date/time of the
below
> > > Gatherer project warning error? Also, check the System Event log for
low
> > > disk space on either your server's system hard drive (usually c:\) as
> well
> > > as on the drive(s) that your FT Catalogs exists on as low disk space
can
> > > cause the Full Population to pause or appear to stop.
> > >
> > > When you say that you changed the security from localsystem to the
> > > domain\administrator account, are you referring to the "Microsoft
> Search"
> > or
> > > MSSQLServer service? If the former, then you MUST change it back to
> > > LocalSystem and then stop & restart the "Microsoft Search" service. If
> the
> > > latter, did you change the account via the Enterprise Manager's Server
> > > property security tab? If not, then you MUST re-change it here as this
> is
> > > the only place that the security for these two service to be sync'ed
> > up'ed..
> > > See KB article 277549 (Q277549) PRB: Unable to Build Full-Text Catalog
> > After
> > > You Modify MSSQLServer Logon Account Through [NT4.0) Control Panel [or
> > Win2K
> > > Component Services] at
> > > http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549 for
more
> > > info.
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > > "Jéjé" <willgart@_A_hAotmail_A_.com> wrote in message
> > > news:e2XBUQKAEHA.2804@tk2msftngp13.phx.gbl...
> > > > Hi,
> > > >
> > > > My full text search in SQL Server return nothing for my sharepoint
web
> > > > sites.
> > > >
> > > > I've a warning in the application log:
> > > > One or more warnings or errors for Gatherer project <SQLServer
> > > > SQL0000900005> were logged to file <C:\Program Files\Microsoft SQL
> > > > Server\MSSQL\FTData\SQLServer\GatherLogs\SQL0000900005.1.gthr>. If
you
> > are
> > > > interested in these messages, please, look at the file using the
> > gatherer
> > > > log query object (gthrlog.vbs, log viewer web page).
> > > >
> > > > After I've exported the GTHR file I have this result:
> > > >
> > > >
> > > > Microsoft (R) Windows Script Host Version 5.6
> > > > Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
> > > >
> > > > 2004-03-02 17:10:58 Add The gatherer has started
> > > > 2004-03-02 17:11:00 Add The initialization has completed
> > > > 2004-03-02 17:11:08 Add Started Full crawl
> > > > 2004-03-02 17:11:08 Add Started Full crawl
> > > > 2004-03-02 17:11:08 Add Started Full crawl
> > > > 2004-03-02 17:11:08 Add Started Full crawl
> > > > 2004-03-02 17:11:20
> > > > MSSQL75://SQLServer/76cba758/80F3ACDE0FFCD0448F2600462A440669 Add
> Error
> > > > fetching URL, (c0000005 - A description for this error could not be
> > found)
> > > > 2004-03-02 17:11:20
> > > > MSSQL75://SQLServer/76cba758/3ABECE04C7D3994D957E00AA6160FF20 Add
> Error
> > > > fetching URL, (c0000005 - A description for this error could not be
> > found)
> > > >
> > > > The 2 last lines are repeated until the end of the file.
> > > >
> > > > What is the problem?
> > > > I've changed the security from localsystem to the
domain\administrator
> > > > account.
> > > > I've cleanup the catalogs
> > > >
> > > > but nothing changes
> > > >
> > > > any idea or guide?
> > > >
> > > > Thanks.
> > > >
> > > > Jerome.
> > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.595 / Virus Database: 378 - Release Date: 2004-02-25
> > > >
> > > >
> > >
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.595 / Virus Database: 378 - Release Date: 2004-02-25
> >
> >
>
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.595 / Virus Database: 378 - Release Date: 2004-02-25

Relevant Pages

  • Re: Restricting Access priviledge on SQL2000
    ... The "Application-Administrators" are neither members of sysadmin nor ... their respective database, but as well as to the defaults database (master, ... then make them members of the db_owner role in that database. ... then add the real SQL Server admins specifically to the ...
    (microsoft.public.sqlserver.security)
  • Re: Restrict sysadmin database access?
    ... Dejan Sarka, SQL Server MVP ... "Paul Ritchie" wrote in message ... > People tell me there are ways to stop even the sysadmin from looking at a ... > Server database, but I just don't see how this can ever happen. ...
    (microsoft.public.sqlserver.security)
  • Re: order of columns
    ... > Bonj, If you understand how SQL Server physically represent the data at the row-level, you will ... > Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)