Re: Full text catalog just not populating
From: DaveK (DaveK_at_discussions.microsoft.com)
Date: 11/05/04
- Next message: Hilary Cotter: "Re: Contains + Special caractere"
- Previous message: Cedric DEBARD: "Contains + Special caractere"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 5 Nov 2004 02:48:01 -0800
John, very quick question if I may.
I've seen a few posts where you've said:
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
My question is, is there any way at all to run FTI without either the
Builtin of Nt authority accounts as sysadmin? It just strikes me as odd that
what is essentially a data read requires such high level permissions. It
means either the network guys in my company who don't know SQL but are admins
of the box becomes SQL admins, or the other services on the box can in theory
gain admin rights. Are there no registry keys, OS permissions or anything
else which can get this working without SA permissions? We try to secure
boxes as much as we can at the server and OS level and then do the same
within SQL. We've build policies specifically so that the domain account
running sql isn't an admin on its box, so ideally we'd avoid giving out sql
admin rights.
Thanks
"John Kane" wrote:
> Carl,
> First of all, thank you for providing the version (@@select) and eventlog
> entries as they are both very helpful info in troubleshooting SQL FTS
> issues! The primary error is "800700e9 - No process is on the other end of
> the pipe." Have you or anyone else changed the MSSQLServer service startup
> account &/or password via Win2K's Component Services? If so, please review
> this 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
>
> Additionally, have you removed or altered the SQL Server login
> BUILTIN\Administrators from the problem server? If so, then this most likely
> is the source of the failure for FT Populations as the MSSearch services
> needs this login to log into SQL Server and you can either add back this
> login with the original permissions (default master db, sysadmin privileges
> or see KB article: 263712 (Q263712) INF: How to Impede Windows NT
> Administrators from Administering a Clustered SQL Server at:
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;263712
>
> If you cannot add back the SQL Server login BUILTIN\Administrators login,
> you can use the following SQL code as a substitute:
>
> 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
>
>
>
>
> "Carl Jones" <belial239@gmail.com> wrote in message
> news:29174ebe.0410270139.33291fef@posting.google.com...
> > Hi all,
> >
> > I spent the best part of the day yesterday scouring this newsgroup,
> > carrying out the routines that are common with FT not populating
> > (checking local system account, checking empty HCR reg entries for
> > empties, making sure local system in sys admin group) but none of them
> > seemed to solve my problem.
> >
> > Whenever I try to do a population of my index, it just stops, the
> > registry contains the errors shown below. I've just spent the best
> > part of an hour going through my registry making sure (and removing
> > where found) empty registry keys (yes, proper empty ones, not the (not
> > set) ones) but that made no difference either.
> >
> > Here's the result of a SELECT @@VERSION
> >
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
> > 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
> > Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> >
> >
> > Could anyone please offer any advice on what to check next, I really
> > need to get this working but unfortunatley am not in a position where
> > I can reinstall the whole server again as it's in production.
> >
> > Any help gratefully appreciated.
> >
> > Thanks
> >
> > // Carl
> >
> > Here are the event log entries as I run the search (top being oldest)
> > and the result from gathrlog.vbs shown below as well.
> >
> >
> > ----------------------------------------------------------------------
> > Event Type: Information
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3019
> > Date: 27/10/2004
> > Time: 10:32:18
> > User: N/A
> > Computer: NUSDB1
> > Description:
> > The crawl on project <SQLServer SQL0000800005> has started.
> >
> >
> > Event Type: Warning
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3035
> > Date: 27/10/2004
> > Time: 10:32:18
> > User: N/A
> > Computer: NUSDB1
> > Description:
> > One or more warnings or errors for Gatherer project <SQLServer
> > SQL0000800005> were logged to file
> > <e:\MSSQL\MSSQL\FTData\SQLServer\GatherLogs\SQL0000800005.2.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).
> >
> >
> > Event Type: Warning
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3036
> > Date: 27/10/2004
> > Time: 10:32:18
> > User: N/A
> > Computer: NUSDB1
> > Description:
> > The crawl seed <MSSQL75://SQLServer/1d864d1d> in project <SQLServer
> > SQL0000800005> cannot be accessed. Error: 800700e9 - No process is on
> > the other end of the pipe. .
> >
> >
> > Event Type: Warning
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3024
> > Date: 27/10/2004
> > Time: 10:32:18
> > User: N/A
> > Computer: NUSDB1
> > Description:
> > The crawl for project <SQLServer SQL0000800005> could not be started,
> > because no crawl seeds could be accessed. Fix the errors and try the
> > crawl again.
> >
> >
> > Event Type: Information
> > Event Source: Microsoft Search
> > Event Category: Gatherer
> > Event ID: 3018
> > Date: 27/10/2004
> > Time: 10:32:18
> > User: N/A
> > Computer: NUSDB1
> > Description:
> > The end of crawl for project <SQLServer SQL0000800005> has been
> > detected. The Gatherer successfully processed 0 documents totaling 0K.
> > It failed to filter 1 documents. 0 URLs could not be reached or were
> > denied access.
> >
> > Event Type: Information
> > Event Source: Microsoft Search
> > Event Category: Indexer
> > Event ID: 7045
> > Date: 27/10/2004
> > Time: 10:32:18
> > User: N/A
> > Computer: NUSDB1
> > Description:
> > The catalog was not propagated, because no new files were detected for
> > the project <SQLServer SQL0000800005>.
> >
> > ----------------------------------------------------------------------
> >
> >
> > Here is the result of ruinning gathrlog.vbs
> >
> >
> > Microsoft (R) Windows Script Host Version 5.6
> > Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
> >
> > 27/10/2004 09:44:22 Add Started Full crawl
> > 27/10/2004 09:44:26 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 09:44:26 Add Completed Full crawl
> > 27/10/2004 09:57:10 Add Started Incremental crawl
> > 27/10/2004 09:57:10 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 09:57:10 Add Completed Incremental crawl
> > 27/10/2004 09:58:52 Add Started Full crawl
> > 27/10/2004 09:58:54 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 09:58:54 Add Completed Full crawl
> > 27/10/2004 10:02:44 Add Started Full crawl
> > 27/10/2004 10:02:44 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 10:02:44 Add Completed Full crawl
> > 27/10/2004 10:06:54 Add The gatherer has started
> > 27/10/2004 10:06:56 Add The initialization has
> > completed
> > 27/10/2004 10:06:58 Add Started Full crawl
> > 27/10/2004 10:07:00 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 10:07:00 Add Completed Full crawl
> > 27/10/2004 10:09:02 Add Started Full crawl
> > 27/10/2004 10:09:04 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 10:09:04 Add Completed Full crawl
> > 27/10/2004 10:26:50 Add The gatherer has started
> > 27/10/2004 10:26:52 Add The initialization has
> > completed
> > 27/10/2004 10:27:08 Add Started Full crawl
> > 27/10/2004 10:27:08 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 10:27:08 Add Completed Full crawl
> > 27/10/2004 10:32:00 Add The gatherer has started
> > 27/10/2004 10:32:00 Add The initialization has
> > completed
> > 27/10/2004 10:32:20 Add Started Full crawl
> > 27/10/2004 10:32:20 MSSQL75://SQLServer/1d864d1d Add Error
> > fetching U
> > RL, (800700e9 - No process is on the other end of the pipe. )
> > 27/10/2004 10:32:20 Add Completed Full crawl
>
>
>
- Next message: Hilary Cotter: "Re: Contains + Special caractere"
- Previous message: Cedric DEBARD: "Contains + Special caractere"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
