| Trevor 2005-04-07, 8:02 pm |
| I would like some assistance if anyone has seen this before.
We have just upgraded the server hardware that our SQL Server 2000
resided on. Previously we were running SQL Server 2000 SP2 on a Win2K
Server platform. Now we have beefed our hardware and also we are
running SQL Server 2000 SP3 on Win2003 Server.
Everything else works fine, but we are unable to do any full-text
indexing.
I check the error logs, and there are no errors. The catalogues create
fine, I do a "start full population" from EM and it says "population in
progress" but never finishes. I recreated one on our old server, and
the population finished within seconds...(this is on a test table)
Things I've already verified from searching this group extensively.
- Event Logs: No errors. It tells me the population has started but
never says anything else, unless I manually stop the population
- BUILTIN\Administrato
rs account is in SQL Server and has sysadmin
rights
- Microsoft Search service is running under local system account. I've
tried restarting it numerous times as well.
- I don't get errors described in
http://support.microsoft.com/defaul...kb;en-us;317746 I don't
get any errors at all. Verified everything they said to do in this
document anyway, and even did the work around. This server is a fresh
install of SQL Server 2000 anyway. 7.0 was never on this server. SO
none of that helped.
- I verified that
HKEY_LOCAL_MACHINE\S
OFTWARE\M=ADicrosoft
\Search\1. 0\Language\n=ADeutra
l]
"WBreakerClass"=3D"{C731071F-AC8=AD0-11D1-8DF3-00C04FB6EF4F}" is in there.
This appears to be the correct one.
- I also verfied that
HKLM\Software\micros
oft\search=AD\1.0\Language\neutral
does not exist in the registry as specified in this thread
http://groups-beta.google.com/group...r.fulltext/bro=
wse_thread/thread/87697aa955a07f7e/
Obviously the problem lies in the fact that we are now running SP3 or
that our SQL Server is now running on Win2003 Server platform. I am at
a loss of what to do next to get this running. I'd be happy to have an
error message to look up, but I don't get any errors. I start
population and it just sits there...even for 24 hours or more. It
never finishes, and never gives me an error message.
print @@version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
Any more info that is needed to help me fix this, I'd be only too happy
to provide.
Many Thanks,
-Trevor
|