Full-text indexing greyed out | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Full-text indexing greyed out

Here is the situation;
-MS Search service is installed and running
-"Full-text indexing…" under Tools menu in Enterprise manager is disabled/greyed out.
-I try to use FTS through Query Analyzer (as suggested in
http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q270671):
exec sp_fulltext_database @action= ‘Enable’
I get:
Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text component cannot be loaded. -I reran Setup, it says FTS is installed. I reboot, nothing.
-If I run SELECT fulltextserviceproperty(‘IsFullTextInstalled’), I get 0 (i.e. FTS is not installed) Any suggestions???
Which edition of SQL is installed?
WHat type of installation mode selected, min/typical/custom? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
SQL2000 is installed and I chose Typical when installing .. But the problem is now , it looks like it’s installed although it’s not and I can’t reinstall..
Review the following files from windows or winnt directory and see any information about FTS setup:
SearchSetup.log
SQLSP.log Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I’ve checked out SearchSetup.log
and it looks like it installed fine. Then I checked the SQLSP.log, it looks also that it applied the service pack without any problems. any ideas?
What is the level of service pack installed on SQL & OS? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Service pack 3 is installed on SQL and windows 2003 is the OS
Try to reinstall FTS by referring the following by using Local Administrator account: Locate the registry key [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL
Server\Tracking…] and remove it. Then delete MSSearch directory and it would be like –
drive_letter::program FilesCommon FilesSystem
Then use SQL installation CD and choose Custome Installation and FTS component should be unchecked.
Refer to SearchSetup.LOG and sqlsp.log for any information. Re-install SQL Server 2000 SP3, so that the newly installed MSSearch components are upgraded to SP3 levels. Restart the MSSearch and MSSQLServer services.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
it worked !!! Thank you so much. Fulya
Bad news!!! I’ve tried this first in a test machine. and it worked, I was excited that it worked, but when I actually wanted to implement it on the production server , it didn’t work. The FTS was again checked, therefore I couldn’t reinstall it. Do you know what might be the reason? Thank you,
Fulya
Are the both servers identical in terms of OS, SQL setup etc.?
I’ve bad feeling you may need to restart from scratch on production server, if not try to approach MS support for any help. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>