SQL Server Full-Text Search - Full-text enabled greyed out

Author

Full-text enabled greyed out

sumeetkbali@gmail.com

2006-02-08, 8:24 pm

Hi Guys,

I have Windows Server 2003 for Small Business Server. I am trying to
make the full-text searches work with Sharepoint. I initially didn't
have MSSearch installed so I went ahead and started the install for SQL
Server 2000 and selected the sharepoint instance of the database (which
usually is comptername\sharepoi
nt) and selected full-text enables from
the list of options that appeared. After I was done with that I went
ahead and re-installed sp4. When I try to search anything in sharepoint
it doesn't work.

The MSSearch service is running under the same account as the SQL
server and there are no error logs pertaining to MSSearch or Sharepoint
under the Application logs. Eventhough MSSearch is installed and
running(its present under services), when I have
computername\sharepo
int database instance selected and go under Tools,
the Full-Text Indexing still appears greyed out(its greyed out even
when I goto a particular table and right click on it).

Any help will be greatly appreciated.

Thanks

Sumeet

sumeetkbali@gmail.com

2006-02-08, 8:24 pm

Also when I goto command prompt and to c:\Program files\Common
Files\System\mssearc
h\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

Hilary Cotter

2006-02-09, 3:24 am

http://www.indexserverfaq.com/tablenotenabled.htm

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

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

<sumeetkbali@gmail.com> wrote in message
news:1139445939.755854.225500@g43g2000cwa.googlegroups.com...
> Hi Guys,
>
> I have Windows Server 2003 for Small Business Server. I am trying to
> make the full-text searches work with Sharepoint. I initially didn't
> have MSSearch installed so I went ahead and started the install for SQL
> Server 2000 and selected the sharepoint instance of the database (which
> usually is comptername\sharepoi
nt) and selected full-text enables from
> the list of options that appeared. After I was done with that I went
> ahead and re-installed sp4. When I try to search anything in sharepoint
> it doesn't work.
>
> The MSSearch service is running under the same account as the SQL
> server and there are no error logs pertaining to MSSearch or Sharepoint
> under the Application logs. Eventhough MSSearch is installed and
> running(its present under services), when I have
> computername\sharepo
int database instance selected and go under Tools,
> the Full-Text Indexing still appears greyed out(its greyed out even
> when I goto a particular table and right click on it).
>
> Any help will be greatly appreciated.
>
> Thanks
>
> Sumeet
>

sumeetkbali@gmail.com

2006-02-09, 1:23 pm

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

Hilary Cotter

2006-02-09, 8:25 pm

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 fulltextserviceprope
rty('IsFulltextInsta
lled')

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.nwsu.com/0974973602.html

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

<sumeetkbali@gmail.com> wrote in message
news:1139509193.550837.161670@z14g2000cwz.googlegroups.com...
> 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
>

sumeetkbali@gmail.com

2006-02-09, 8:25 pm

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

Thanks again Hilary.

When I run "select fulltextserviceprope
rty('IsFulltextInsta
lled') "
under my computername\sharepo
int 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://support.microsoft.com/defaul...B;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

sumeetkbali@gmail.com

2006-02-09, 8:25 pm

Thanks again for your reply and you were right.

I get back a 0 when I run the select command under
computername\sharepo
int 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

sumeetkbali@gmail.com

2006-02-09, 8:25 pm

Hi guys,

New things that I tried.

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

2. Tried to delete C:\Program Files\Common Files\System\MSSearc
h 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\S
OFTWARE\Microsoft\Se
arch 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\MSSearc
h\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\S
earch\Install:Versio
n 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\FullT
ext\MSSearch\Search\
SearchStp.exe" /s
/ a:SQLServer$SHAREPOI
NT
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 fulltextserviceprope
rty('IsFulltextInsta
lled') and got a 0.

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

Hilary Cotter

2006-02-10, 9:23 am

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.nwsu.com/0974973602.html

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

<sumeetkbali@gmail.com> wrote in message
news:1139532743.922178.251080@o13g2000cwo.googlegroups.com...
> Hi guys,
>
> New things that I tried.
>
> 1. command prompt->regedit and I renamed
> HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\Mi
crosoft SQL
> Server\<Instance_Name>\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}.
>
> 2. Tried to delete C:\Program Files\Common Files\System\MSSearc
h 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\S
OFTWARE\Microsoft\Se
arch 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\MSSearc
h\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\S
earch\Install:Versio
n 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\FullT
ext\MSSearch\Search\
SearchStp.exe" /s
> / a:SQLServer$SHAREPOI
NT
> 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 fulltextserviceprope
rty('IsFulltextInsta
lled') and got a 0.
>
> Today off to drink, tommorrow go postal(take the day off and play Halo,
> Halo-2 and Doom all day).
>

sumeetkbali@gmail.com

2006-02-10, 1:23 pm

Hi Hilary,

Thanks again for your help.

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

Thanks

Sumeet

Hilary Cotter

2006-02-10, 8:24 pm

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.nwsu.com/0974973602.html

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

<sumeetkbali@gmail.com> wrote in message
news:1139599175.157871.32820@g44g2000cwa.googlegroups.com...
> Hi Hilary,
>
> Thanks again for your help.
>
> So are you telling me to do the whole process again with the restart?
>
> Thanks
>
> Sumeet
>

Sponsored Links