Hello

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msnews.microsoft.com - 26 Jan 2005 04:17 GMT

How do I start the Search Service on my SQLServer 2000 on winxpsp2 ?

I have installed it, but in the Service Manager I see only

DTC
OLAP SERVICE
SQL Server
SQL Server Agent

I read that I should see an etry named "Search Service" in the Service
Manager.

In Enterprise Manager if I right-click on a table, the entry "Full-Text
Index Table" is disabled.

Reply to this Message

msnews.microsoft.com - 26 Jan 2005 04:36 GMT

Sorry, I accidentally pressed Send before finishing my question.

- Does my problem have something to do with the "Indexing Service" Service
(C:\WINDOWS\System32\cisvc.exe) which was stopped ? I started it, and
nothing changed.
- Does it have anything to do with the "Indexing Service" in Explorer ? You
press CTRL+F and previously it said "The indexing service on this computer
is currently stopped" blah-blah-blah something. Now it's running (it says
"Indexing Service is currently building an index of files on your local
drives").

Still, after starting all this (the service in ComponentServices, and the
Indexing Service in Explorer (in Computer Management I see the status of the
Indexing Service as "Scanning").... in in the Service Manager I still cannot
see any new service related to the EnglishQuery (or FullText, or Search
Service, or whatever). What do I have to do to make it run, please ?

Thanks a lot for your time.
Alex.

> How do I start the Search Service on my SQLServer 2000 on winxpsp2 ?
>
[quoted text clipped - 10 lines]
> In Enterprise Manager if I right-click on a table, the entry "Full-Text
> Index Table" is disabled.

Reply to this Message

John Kane - 26 Jan 2005 05:50 GMT

Alex,
Not to worry as I too did this today <g>.
Some basic information, while the "Indexing Service" (cisvc.exe) and the
"Microsoft Search" (mssearch.exe) service are built from the same underlying
Microsoft Search technology, they are in fact two different services. The
Indexing Service is used to full text index or "crawl" files on your
server's local disk drive, while the Microsoft Search service is used in
conjunction with SQL Server 2000 as well as Exchange and other server
technologies.

Assuming (from your first post) that you want to know how to start and use
the "Microsoft Search" (mssearch.exe) service with my SQLServer 2000 on
winxpsp2 (WinXP SP2), and as the "Microsoft Search" service is installed by
default for SQL Server 2000 Standard edition and above, but not for SQL
Server 2000 Developer's edition. Could you confirm that you are using SQL
Server 2000 Developers Edition by posting the full output of -- SELECT
@@version -- as this would help confirm your environment.

Assuming for the time being, that you are using the developer's edition, you
can install the "Microsoft Search" service and the SQL Server 2000 Full-text
Search components via you're SQL CD and selection "custom installation" and
under Server components, select "Full-text Search" and it will install the
MSSearch service and other related components. Note, if you have installed
previous SQL Server 2000 service packs, you will want to re-apply that SP in
order to get the fixes to the FTS components applied to your newly installed
FTS components.

Hope that helps!
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Sorry, I accidentally pressed Send before finishing my question.
>
[quoted text clipped - 30 lines]
> > In Enterprise Manager if I right-click on a table, the entry "Full-Text
> > Index Table" is disabled.

Reply to this Message

msnews.microsoft.com - 26 Jan 2005 06:40 GMT

Thank you very much for your post. Yes, I have the developer's edition - I
have re-installed everything and now I can see Microsoft Search in the list
of services. Also, "Full text indexing" is now available. It works !

Something a bit strange, though: my standalone computer is named "RADU". The
SQL Server's name is RADU. I connect in ASP.NET with a string like
"server=radu;database=northwind; integrated security=sspi;"

Now, however, my Service Manager shows "two servers": "Radu" and
"Radu\Radu". Hmmmmm...... But in Enterprise Manager I see only one server
group, named "(local)(Windows NT)".

I must confess to you that although I'm a pretty good programmer, I'm
definitely not a good dba (LOL) especially on issues regarding NT and SQL
security and sometimes setup, as in this instance. Have I done something bad
reinstalling SQL altogether on top on my previous installation ? I took care
to specify the same server name, RADU, and yes, my previous dbs are still
there, in great shape. The only thing which worries me a bit is that I see,
as I mentioned above, "two" servers in Service Manager. Is this a problem,
or is it only a bug in the installation procedure ?

Anyway, thanks a lot for your advice - the misunderstanding came from the
fact that when starting to learn about "full-text query" I confused it with
another install option, "English Query" (I thought thay maybe my book is now
outdated and MS changed the name of this feature from "Full-Text" to
"English Query"). So I installed "English Query" and I started to struggle
to see "Full text indexing" becoming enabled.

Thanks again,
Alex.

> Alex,
> Not to worry as I too did this today <g>.
[quoted text clipped - 71 lines]
>> > In Enterprise Manager if I right-click on a table, the entry "Full-Text
>> > Index Table" is disabled.

Reply to this Message

Hilary Cotter - 26 Jan 2005 14:37 GMT

English Query is a completely separate product from SQL FTS. While English
Query can issue Full Text Queries, they are different products.

Radu\Radu means you have created another SQL Server running on your machine
with an instance name of Radu.

Signature

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

> Thank you very much for your post. Yes, I have the developer's edition - I
> have re-installed everything and now I can see Microsoft Search in the list
[quoted text clipped - 102 lines]
> >> > In Enterprise Manager if I right-click on a table, the entry "Full-Text
> >> > Index Table" is disabled.

Reply to this Message

John Kane - 27 Jan 2005 02:58 GMT

You are most welcomed, Alex,
The SQL Server with the name "Radu\Radu" is called a "named instance" of SQL
Server where the second "Radu" is the instance's name. You may need to
register it in your Enterprise Manager in order to see it in that tool. Not
to worry, check-out my "SQL Full Text Search Blog" from time-to-time as I
intend to expand upon the existing SQL Server 2000 Full Text Search (FTS)
and SQL Server 2005 FTS content in the coming months.

Hope that helps!
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

Reply to this Message