Re: catalog is empty after populating

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

  • Next message: anonymous_at_discussions.microsoft.com: "Re: catalog is empty after populating" 
    Date: Mon, 9 Aug 2004 07:48:50 -0700

    Andre,
    Hilary's referring to the Window's Application Event log on the server where
    SQL Server is installed as the "Microsoft Search" service cannot write it's
    errors to SQL Server's errorlog files as SQL Server has a lock on these
    files. Specifically, you should click on Start -> Programs -> Administrator
    Tools -> Event Viewer and review the Application event log. You can click on
    View and Filter and then select "Microsoft Search" as the Event Source to
    see only these events. Below is an example error, you may find or you may
    find a different error.

    Microsoft Search
    Warning Gatherer
    3036
    JTKNT0
    Unable to access crawl seed <MSSQL://LOCALHOST/7.1333579789> in project
    <SQLServer SQL0000700006>.
    Error: 8007052e - Logon failure: unknown user name or bad password. .

    Post any related errors in your server's Application event log.
    Regards,
    John

    "André Bretschneider" <andre.bretschneider@freenet.de> wrote in message
    news:2b0901c47e0b$f559ce60$a601280a@phx.gbl...
    Hi Hillary,

    thanks for your fast answer, But I'm sorry. I'm obviously
    a greenhorn in SQLServer-Administration. Where can I find
    this application log?

    André

    >-----Original Message-----
    >what are the error messages you are getting in the
    application log in event
    >viewer from MSSearch and MSSCi?
    >--
    >Hilary Cotter
    >Looking for a book on SQL Server replication?
    >http://www.nwsu.com/0974973602.html
    >
    >
    >"André Bretschneider" <andre.bretschneider@freenet.de>
    wrote in message
    >news:2a0701c47df8$4bd41c50$a601280a@phx.gbl...
    >Hello,
    >
    >I've got a problem with the Full Text Search of MS SQL
    >Server 2000 (SP3).
    >
    >I've created a new Full Text catalog (FTC) on a database,
    >including one table and one textfield for searching. Up to
    >this everything goes fine. Population runs without
    >creating an error. But after population the catalog-size
    >is only 1 MB and the catalog doesn't contain any items. A
    >query with CONTAINS is returning 0 results.
    >
    >I've tried the total procedure in Enterprise Manager and
    >in Query Analyzer. I've tried it with the example
    >databases NORTHWIND and PUBS, but everytime the same
    >result.
    >
    >I've already searched a lot of articles and newsgroup-
    >entries without finding a solution for my problem.
    >Hopefully one of You may help.
    >
    >Some facts that may help to find a solution:
    >-SQL Server 2000 SP3 (not upgraded from 7.0)
    >-Windows 2003 Server as Operating System
    >-MS Search Service runs correctly
    >
    >Thank You in advance for every help
    >
    >André
    >
    >
    >.
    >

  • Next message: anonymous_at_discussions.microsoft.com: "Re: catalog is empty after populating"

    Relevant Pages

    • Re: Unknown full-text failure (8007007e) occurred in function EnumCatalogs on full-text cata
      ... from your server's Application event log (always the first place to look for ... it is ok for both the MSSQLServer and "Microsoft Search" be running ... > The same database under SQL Server Personal works ... > - Microsoft Search service, and SQL Agent service have started (with no ...
      (microsoft.public.sqlserver.fulltext)
    • Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
      ... situation (event log overload from transaction replication on 40+ DBs). ... Go to the SQL Server Properties via Enterprise Manager (i.e. right ... Erland Sommarskog wrote: ... TRACEOFF turns off the trace flag! ...
      (comp.databases.ms-sqlserver)
    • Full Text Indexing Error
      ... I see a lot of these in my Event log on the SQL Server for my Windows ... These documents will not be passed to MSSearch for indexing, ... therefore this failure will not be reflected in the end of crawl summary ...
      (microsoft.public.sqlserver.fulltext)
    • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
      ... Associated with this is event id 17055 from MSSQLSERVER w/description 18456: Login failed for user NT ... These messages occur in bursts of of over 100 messages every 5 minutes and just flood the application event log w/entries I think what's going on is the Alert Engine is a service running under local system and is unable to connect to SQL server. ...
      (microsoft.public.sqlserver.server)
    • Re: Cannot Connect to Configuration Database
      ... <Event Log> ... Source: Windows SharePoint Services ... the database connection information and make sure that the database server ... >> The install is in server farm mode and the SQL server is on another box. ...
      (microsoft.public.sharepoint.windowsservices)