SQL Server, MS search service problems

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> MS search service problems

by jj » Wed, 15 Sep 2004 23:24:27 GMT

I have a SQL 2000 sp3a (8.00.818) server running on W2K3 that cannot run the
MS Search service. The executable is present but when I checked for the
catalogs, the "Program Files\Microsoft SQL Server\MSSQL\FTDATA" folder was
empty. I have one other SQL server with the same exact problem. Any ideas on
how this might have happened?

More importantly how do I reinstall MS Search without reinstalling SQL
server entirely?

TIA!!!
jj



Top

SQL Server >> MS search service problems

by Hilary Cotter » Thu, 16 Sep 2004 00:19:46 GMT


MSSearch lives in C:\Program Files\Common Files\Microsoft
Shared\MSSearch\Bin

To verify it is working issue a net start mssearch from the command prompt
and see what you get.

I suspect that it is not installed.

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




the
on




Top

SQL Server >> MS search service problems

by jj » Thu, 16 Sep 2004 01:55:37 GMT

Actually the directory is C:\Program Files\Common Files\System\MSSearch\Bin.
When I try a netstart I get: "System error 3, the system cannot find the
path specified."

So how do I reinstall it?

jj










Top

MS search service problems

by Hilary Cotter » Thu, 16 Sep 2004 02:29:10 GMT

I think the more important question is how did this directory get whacked.
What else has been whacked?

To reinstall MSSearch or SQL FTS follow these directions:

http://groups.google.com/groups?selm=MPG.14cd6d851f79df7598987f %40msnews.microsoft.com&output=gplain

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




Files\System\MSSearch\Bin.


prompt


run
ideas



Top

MS search service problems

by Hilary Cotter » Thu, 16 Sep 2004 02:30:24 GMT

You might have to look in this key as well

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\InstanceName\Tracking

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




Files\System\MSSearch\Bin.


prompt


run
ideas



Top

MS search service problems

by jj » Thu, 16 Sep 2004 03:40:42 GMT

Thanks so much, I'll try the suggestions in this document right away.

jj













Top
Similar Threads

1. MS Search Service on Act/Act Sql 2k SP3 Cluster Failing

2. MS Search service not working 

Hello,
I have not been able to start the MS Search service on a W2K3 SQL 2000 box 
since I installed it. I have reinstalled the Full Text component multiple 
times.

The problem seems to be that somehow the MS Search service is looking for 
files on a network drive instead of on the local drive. In the service 
itself the "Path to executable" lists this: "H:\Program Files\Common 
Files\System\MSSearch\Bin\mssearch.exe". This is my personal home folder.

How can I switch this path?

Thanks
jj

3. MS Search Service didn't install

4. problem in freetext search in MS SQL Server 

hi

i have problem in fulltex search, when i search any
english word it give me perfect result.

In my table i have define fulltext search on a column
name content_html, data type of column is ntext it
stores htlm content.

now when i search any unicode character(gujarati word)
it shows me content which not contain the search
value.

if anyone know the solution

pls help urgent

5. problem in fulltext search in MS SQL Server - SQL Server

6. Problems with search service SQL queries and their order by

7. Oracle connection problems (MS SQL Reporting Services) - Oracle

8. Problem while installing Japanese MS Analysis Services 

Hi
My name is Kajol. I am trying to install Japanese MS Analysis Services on a Japanese OS. THe problem is I am able to process the cubes, but if I try to browse the processed cude, it gives me error. I have checked the MDAC version also. Its 2.7 Is there anything that I am missing out.
Kindly get back to me asap

Thanks in Advance
Kajol