Installing Full Text Search
-
I'm trying to install the MS Search engine and Full Text Search on our SQL2000 machine.
I'm using the procedures outlined here http://support.microsoft.com/?kbid=827449 and the MS Search engine part installs with no errors, the service runs and everything is good in the world.
Until, that is, I try and install the Full Text search part using the following:
\x86\FullText\ftsetup.exe" SQLServer Domain Name\User Account 1 0 0 0 > C:\MyFTSetup.log
The log file has the following error: FulltextSetup returned error code: 0x80000023
And thats it, I can't find anything retating to this error in google or googlenews. And of course FT indexing isn't installed
Could anyone help?
-
Why are you installing the Full-text Search components on your SQL Server 2000 machine in the first place? If you're using SQL Server 2000 Standard Edition & above, the FTS components are installed by default. If you're using the Developer Edition, you can use your SQL Server 2000 DE CD and install the FTS components via "custom installation". The procedures in KB 827449 should only be used for "reinstal" and not for the inital installation.
I'd recommend re-installing the "Full-text Search" components via deleting (or renaming) the
below "tracking key" and re-install (If you're not using a named instance, remove "<Instance_Name>\".)
NOTE: be sure to be logged on to the server as either Administrator or as a member of the server's Admin Group!
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance_Name>\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Once you've done removed (renamed) the above tracking key, then delete the MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared
or
drive_letter::\Program Files\Common Files\System
Then using your SQL Server 2000 installation CD re-install via "Custom Installation" the Full-Text Search component (it should be un-checked). When this completes find and save these files: SearchSetup.log (usually under \windows or \winnt folders) and sqlsp.log. If any problems, please post these files.
If you have applied any Service packs (SP3a is the most recent), then you should re-apply the service pack, so that the newly installed MSSearch components are upgraded to your current SP level and then re-boot &/or restart the MSSearch and MSSQLServer services.
Regards,
John T. Kane -
Why am I installing it?
Because it wasn't installed by default, or it was intentionally not installed. We haven't had need of it till this development round. I didn't install the server originally so aren't aware of the initial requirements or settings, all I know is that we needed it now
It turns out I was looking in the wrong place anyway, and I resolved the issue by a similar method that you instructed. I popped the SQL CD in the drive and installed the missing component, it still didn't work, but then I re-ran SP3 and after that it was working fine.
Thanks for replying to my question tho.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply