Full-text enabled greyed out

Full-text enabled greyed out

Post by sumeetkbal » Fri, 10 Feb 2006 10:18:16


Also when I goto command prompt and to c:\Program files\Common
Files\System\mssearch\bin and type mssearch.exe get an error in the
application log

Event Source: Microsoft search, Category: Gatherer, Type: Error, Event
ID 3006

Description: Performance monitoring for the Gathere service cannot be
initialized because the countes are not loaded or the shared memory
object cannot be opened. This only affects availability of the perfmon
counter. Rebooting the system may fix the problem.

But even after the reboot nothing happens. And I don't have
mssearch.dll in the bin folder but I have mssearch.dll which might be
used in case I wanted to re-register my dlls.

This was just additional information that I wanted to give it in case
somebody could make any sense out of it.

Thanks

Sumeet
 
 
 

Full-text enabled greyed out

Post by Hilary Cot » Fri, 10 Feb 2006 14:25:46

http://www.yqcomputer.com/

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/

 
 
 

Full-text enabled greyed out

Post by sumeetkbal » Sat, 11 Feb 2006 03:19:53

Thanks for your reply.

I was logging on to the box where the SQL was as an admin so I was
already part of the local administrators but I still went ahead and
added the administrator user. I then ran the script in Query Analyzer
for the particular database and then saw the dbo change to 'NT
Authority\System'. Still the FTS was greyed out. I went to command
prompt and under C:\Program Files\Microsoft SQL Server\80\Tools\Binn
wrote sqlftwiz /n /sSQLServerName[\InstanceName] /dDatabaseName. After
filling out the fields when I clicked the Finish button it told me that
the Search wasn't installed.

How could that be when there is an MSSearch service running under
services, also if you rt-click on the SQL-Server icon in your tray and
under the services running on \\computername you see Microsoft Search?

I guess my only option right now is to re-install the Search. If
anybody has any better idea or any idea at all then please let me know.

Thanks again for your help Hillary,

Sumeet
 
 
 

Full-text enabled greyed out

Post by Hilary Cot » Sat, 11 Feb 2006 05:09:25

Can you verify it really is installed for this SQL Server instance - other
MS applications use MSSearch - Exchange and Sharepoint Portal Server do.

Issue a select fulltextserviceproperty('IsFulltextInstalled')

If you get 1 it is installed, if you get 0 it is not.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/
 
 
 

Full-text enabled greyed out

Post by sumeetkbal » Sat, 11 Feb 2006 07:04:12

My last post didn't show up so I am posting again.

Thanks again Hilary.

When I run "select fulltextserviceproperty('IsFulltextInstalled') "
under my computername\sharepoint instance I do get a 0(I have SQL 2000
standard edition sp4). But when I put in the install CD and select my
instance name and goto the add components window, FTS is already
selected and it doesn't let me go any further with the install saying
that no new components were selected to be added.

Following
http://www.yqcomputer.com/ ;en-us;q270671 I tried
sp_fulltext_database @action='enable' in query analyzer for a
particular database in my sql instance and it gave me this error

"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. "

Again I am lost and look forward to any ideas or help.

Thanks again Hilary for your help. I really appreciate it.

Sumeet
 
 
 

Full-text enabled greyed out

Post by sumeetkbal » Sat, 11 Feb 2006 07:04:51

Thanks again for your reply and you were right.

I get back a 0 when I run the select command under
computername\sharepoint instance but when I run the SQL 2000 install,
select to add or upgrade existing components in my SQL sharepont
instance, it doesn't let me continue do so saying that No new
components have been selected and thus doesn't let me install FTS for
my particular instance?

Thanks for all your help so far Hilary. I really appreciate it.

Sumeet
 
 
 

Full-text enabled greyed out

Post by sumeetkbal » Sat, 11 Feb 2006 09:52:23

Hi guys,

New things that I tried.

1. command prompt->regedit and I renamed
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}.

2. Tried to delete C:\Program Files\Common Files\System\MSSearch but
wasn't able to.

3. Went in manually and was able to delete most of the files except
tquery.dll, proppdefs.dll and mssws.dll as it kept saying that these
files were in use.

4. Unregistered these files using regsvr32 /u but still wasn't able to
delete them(wasn't able to unregister mssws.dll) . Went under services
and stopped all sql server instances and tried to delete the files
again and still didn't work.

5. Under registry editor deleted
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search and then started to
install sql server 2000. Selected my sharepoint instance and selected
to install Full-text service from the sub-components. After install was
finished, opened up the searchsetup.log under local settings\temp and
saw that the installation had taken place. Since I wasn't able to
delete some of the dlls in the MSSearch folder so the log contained
lines like

2/9/2006 16:39:59 INFO: InstallFile, SetupInstallFile did not replace
file : C:\Program Files\Common Files\System\MSSearch\Bin\mssws.dll

for mssws.dll, athprxy.dll, propdefs.dll and gathercl.dll and at the
end it contained these lines

2/9/2006 16:40:36 INFO: CSearchSetupEngine, Search setup completed.
2/9/2006 16:40:36 INFO: Main,
********************************************
2/9/2006 16:40:36 INFO: Main, *** Setup is ending. Returning
0x00000000
2/9/2006 16:40:36 INFO: Main,
********************************************

The c:\windows\sqlstp.log had the following log:

16:39:35 Begin Action InstallPkgs:
16:39:35 InstallMSSearch instance: SHAREPOINT
16:39:35 Software\Microsoft\Search\Install:Version not present
16:39:35 MSSearch 2.0 or greater version check returned -1
16:39:36 Setup is installing the Microsoft Full-Text Search Engine ...
16:39:36 "G:\SQL2000\x86\FullText\MSSearch\Search\SearchStp.exe" /s
/a:SQLServer$SHAREPOINT
16:40:36 Process Exit Code: (0)

Didn't restart the computer since it wasn't required as it said so in
the searchsetup.log file.

Started to install sp3a and it bombed out saying that another version
was already there(sp4).

Under services MSSearch and all the SQL instances were now running.

Went to SQL query analyzer for the sharepoint instance and typed

select fulltextserviceproperty('IsFulltextInstalled') and got a 0.

Today off to drink, tommorrow go postal(take the day off and play Halo,
Halo-2 and Doom all day).
 
 
 

Full-text enabled greyed out

Post by Hilary Cot » Sat, 11 Feb 2006 23:52:43

The reason you can't delete these files is they are loaded and you need to
reboot to be able to delete them.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/
 
 
 

Full-text enabled greyed out

Post by sumeetkbal » Sun, 12 Feb 2006 04:19:35

Hi Hilary,

Thanks again for your help.

So are you telling me to do the whole process again with the restart?

Thanks

Sumeet
 
 
 

Full-text enabled greyed out

Post by Hilary Cot » Sun, 12 Feb 2006 08:23:37

No, I am merely saying this is how to prevent these files from being locked,
or how to unlock them.

Unfortunately, I have been unable to fix problems like the one you have
encountered without removing SQL Server and reinstalling.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/