Full text catalog just not populating

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\SQL000 0800005.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
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...B;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...B;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.c om...
> 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\SQL000 0800005.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
|||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...B;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...B;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.c om...
>
>