Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)
Oct 24 2000 18:39:12
Copyright (c) 1988-1998 Microsoft Corporatio
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2

I'm having trouble populating a full text catalog. Everytime I start population, item count is 0 and there are "crawl" errors in the event log. I've read the KB articles about logins and have checked and rechecked them.
I've run the following to make sure the right permissions are set
EXEC sp_grantlogin [NT Authority\System
EXEC sp_addsrvrolemember @loginame = [NT Authority\System], @rolename = 'sysadmin

I'm pretty sure login's aren't the problem at this point.

Any Suggestions

Arthur,
What (if any) "Microsoft Search" or MssCi source events (warnings or errors)
are posted to your server's Application event log when you attempt a Full
Population? If there are any errors or warning, could you post them here?

By including the sp_grantlogin info below, can I assume that you have
removed the BUILTIN\Administrators login? If so, could you confirm that the
following settings are also set on this problem server?:

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

Thanks,
John



[quoted text, click to view]
population, item count is 0 and there are "crawl" errors in the event log.
I've read the KB articles about logins and have checked and rechecked them.
[quoted text, click to view]

Thanks John..

<----------------
One or more warnings or errors for Gatherer project <SQLServer SQL0001000005> logged to file <D:\MSSQL7\FTDATA\SQLServer\GatherLogs\SQL0001000005.2.gthr>.

Unable to access crawl seed <MSSQL://LOCALHOST/10.350920663> in project <SQLServer SQL0001000005>. Error: 80072ee2 - The operation timed ou
..

Unable to start crawl for project <SQLServer SQL0001000005>. No crawl seeds could be accessed.
<----------------

Actually, the BUILTIN\Administrators login is still there and was never removed. I was just trying anything to get it to at least populate

Thanks
-Arthu

You're welcome, Arthur,
Below are some basic troubleshooting items to check for: error "80072ee2,
The operation timed out":
1. Check that the login (sysxlogins): BUILTIN\Administrators exists.
2. Check the default database for BUILTIN\Administrators is master.
3. Check that the MSSQLServer startup account also has default database of
master.
4. Check for missing "DOMAIN\MSSQLServer_Startup_Account" login...
5. Confirm that the MSSQLServer has NT Administrator rights & is member of
Local. Admin Grp.
6. Confirm that NO changes have been made to MSSQLServer startup account
via the Control Panel or Win2K Component Services.

Additionally, and since BUILTIN\Administrators is still present, could you
confirm that it has the proper settings?
In the past, when BUILTIN\Administrators login was removed and we re-added
it, but this alone did not resolve the problem and while you may not of
changed the MSSQLServer startup account via the Control Panel's Services
applet from a DOMAIN\account to LocalSystem. Note, this usually generates a
"Bad login or password" error in the NT Application log, however I'm
assuming that in your case this error is not present.

Nonetheless, could you change the MSSQLServer startup account via the
Enterprise Manager's Server's Security tab from whatever is the present
account to LocalSystem and then re-change it back to the same account? This
forces a stop & start of SQLServer and a re-sync of the security rights
between the two services. This should allow you to successfully populate the
FT Catalog. FYI, ALL changes to the MSSQLServer startup account MUST be done
in the Enterprise Manager.

Regards,
John



[quoted text, click to view]
SQL0001000005> logged to file
<D:\MSSQL7\FTDATA\SQLServer\GatherLogs\SQL0001000005.2.gthr>.
[quoted text, click to view]