Re: Full Text Indexing not Populating

From: John Kane (jt-kane_at_comcast.net)
Date: 09/16/04

  • Next message: JayB: "Re: Full Text Indexing not Populating" 
    Date: Thu, 16 Sep 2004 10:36:08 -0700

    You're welcome, JayB,
    Have you or anyone else changed the MSSQLServer service startup account &/or
    password via Win2K's components service? Also, does the SQL Server login
    BUILTIN\Administrator exist on this server with all of it's normal defaults:
    master database, SysAdmin rights? Depending upon your answers, you should
    review the following KB articles:

    317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
    http://support.microsoft.com/default.aspx?scid=kb;en-us;317746

    277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
    MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
    Services]
    http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549

    If the BUILTIN\Administrator account was removed for security reasons, you
    can use the following SQL code to get FTS to work without it:

    exec sp_grantlogin N'NT Authority\System'
    exec sp_defaultdb N'NT Authority\System', N'master'
    exec sp_defaultlanguage N'NT Authority\System','us_english'
    exec sp_addsrvrolemember N'NT Authority\System', sysadmin

    Regards,
    John

    "JayB" <jerry280@yahoo.com> wrote in message
    news:7Yj2d.4154$wK5.3659@news01.roc.ny...
    > After stopping and restarting the population I looked at the event viewer
    > and have one event ID of 3019 indicating that the crawl has started. That
    > was at 12:06pm. It is now 12:20pm. There are no other messages related to
    > this population.
    >
    > --
    > JayB
    >
    >
    > "John Kane" <jt-kane@comcast.net> wrote in message
    > news:OmrswgAnEHA.3988@TK2MSFTNGP10.phx.gbl...
    > > JayB,
    > > How many rows are in the FT-enable SQL Server 2000 table? The time for
    the
    > > "Microsoft Search" (mssearch.exe) service to complete a Full Population
    is
    > > highly dependent upon the number of rows as well as where you have the
    FT
    > > Catalog defined. Could you post the output of -- select count(*) from
    > > <your_table> -- as that will give us some idea of how long it should
    take
    > to
    > > complete.
    > >
    > > Also, you should review your server's Application event log for
    "Microsoft
    > > Search" or MssCi source events, such as the following two events as
    this
    > > will indicate that the final stage (Master Merge) of a Full Population
    has
    > > completed.
    > >
    > > Event Type: Information
    > > Event Source: Microsoft Search
    > > Event Category: Gatherer
    > > Event ID: 3018
    > > Date: 9/16/2004
    > > Time: 9:10:32 AM
    > > User: N/A
    > > Computer: JTKWIN2003
    > > Description:
    > > The end of crawl for project <SQLServer$SQL2K SQL0000500007> has been
    > > detected. The Gatherer successfully processed 24 documents totaling 0K.
    It
    > > failed to filter 0 documents. 0 URLs could not be reached or were denied
    > > access.
    > >
    > > and
    > >
    > > Event Type: Information
    > > Event Source: MssCi
    > > Event Category: None
    > > Event ID: 4103
    > > Date: 9/16/2004
    > > Time: 9:10:32 AM
    > > User: N/A
    > > Computer: JTKWIN2003
    > > Description:
    > > Master merge has completed on
    > > f:\mssql80\mssql$sql2k\ftdata\sql0000500007\build\indexer\cifiles.
    > >
    > > You can also issue the following SQL metadata query to get the FT
    > Population
    > > status on a per FT Catalog basis:
    > >
    > > USE Northwind
    > > GO
    > > SELECT fulltextcatalogproperty('<your_FT_Catalog_name>',
    'PopulateStatus')
    > >
    > > Regards,
    > > John
    > >
    > >
    > >
    > >
    > >
    > >
    > > "JayB" <jerry280@yahoo.com> wrote in message
    > > news:Mxi2d.4150$uM5.1342@news01.roc.ny...
    > > > When I start the population it doesn't appear to stop. I don't think
    it
    > > even
    > > > starts. What I mean is when I right-click on the table and choose
    start
    > > full
    > > > population, I go back to check and the only active choice is to stop
    the
    > > > population. After 24 hours it appears to still be running (or trying
    to
    > > > run). I'm using SQL 2000. I tried to do this on a copy of the same
    table
    > > on
    > > > a different server and it works fine. I tried this on a different
    table
    > > (and
    > > > different database) on the same server and get the same issue.
    > > >
    > > > Any suggestions?
    > > >
    > > > --
    > > > JayB
    > > >
    > > >
    > >
    > >
    >
    >

  • Next message: JayB: "Re: Full Text Indexing not Populating"

    Relevant Pages

    • Re: Full Text Indexing not Populating
      ... We haven't changed the startup account and we made sure that the ... > You're welcome, JayB, ... SQL Server Full-Text Search Does Not Populate ... > exec sp_defaultdb N'NT Authority\System', ...
      (microsoft.public.sqlserver.fulltext)
    • Re: update index in background not running.
      ... in order to allow an .net web program to access the SQL server you have to ... add IIS_WPG account to the database, ... > exec sp_defaultdb N'NT Authority\System', ...
      (microsoft.public.sqlserver.fulltext)
    • RE: Use a Trusted Connection With OPENROWSET?
      ... The OPENROWSET is done in the context of the SQL Server account that is ... Most of the time it is the local machine account. ... > EXEC master..sp_who2') AS a ...
      (microsoft.public.sqlserver.connect)
    • Re: The Microsoft Search service cannot be administered under the pres
      ... the BUILTIN\Administrator account as well as a member of the Sysadmin role? ... SQL Server Full-Text Search Does Not Populate Catalogs ... you or your server's sysadmin have removed the ... exec sp_defaultdb N'NT Authority\System', N'master' ...
      (microsoft.public.sqlserver.fulltext)
    • Re: Cant Administer
      ... Can you verify that the MSSearch account is running under the local system ... Has anyone modified the SQL Server service account through the ... system administrators role. ... exec sp_defaultdb N'NT Authority\System', N'master' ...
      (microsoft.public.sqlserver.fulltext)