How to reinstall?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arthur Dent - 20 Jul 2005 04:06 GMT

Hello all,

can anyone tell, is there anyway to reinstall/repair full-text without
having to actually uninstall and resintall the whole Sql Server?

Thanks in advance,
- Arthur Dent.

Reply to this Message

Hilary Cotter - 20 Jul 2005 10:40 GMT

http://support.microsoft.com/default.aspx?scid=kb;en-us;827449

Signature

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

> Hello all,
>
[quoted text clipped - 3 lines]
> Thanks in advance,
> - Arthur Dent.

Reply to this Message

Arthur Dent - 21 Jul 2005 04:35 GMT

Thank you very much for the link.
I checked it and went through all the steps.
My full text is still not working however.
I have the menu-options all there in Enterprise Manager,
however they are all greyed out.

The log file from the Full-Text command-line install contained
the following message:

FulltextSetup returned error code: 0x0

Any ideas?
Thanks in advance,
- Arthur Dent.

Reply to this Message

Hilary Cotter - 21 Jul 2005 11:06 GMT

You may be running into this problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;270671

or check this out

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

Signature

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

> Thank you very much for the link.
> I checked it and went through all the steps.
[quoted text clipped - 10 lines]
> Thanks in advance,
> - Arthur Dent.

Reply to this Message

Arthur Dent - 21 Jul 2005 15:02 GMT

I dont think it is a security issue. I had had FT working perfectly on my
system before.
Then i installed a sql tool, to try out. It was slow, so i removed it,
however the uninstall
was not well-behaved and took a bunch of the SS system files with it,
effectively killing
my install of the client tools.
So i uninstalled Sql Server, and then reinstalled it, and now i cant get FTS
working again.

> You may be running into this problem.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;270671
[quoted text clipped - 17 lines]
>> Thanks in advance,
>> - Arthur Dent.

Reply to this Message

Arthur Dent - 21 Jul 2005 15:11 GMT

Heres some more info... if i try to run the FT wizard through Tools >
Wizards, i get a message that says
"The Full-Text Server service needs to be running in order to open this
wizard."

Which service is it? The Microsoft Search service already is running.
The Indexing Service wasn't so i started that, but that didnt help.

Is somehow my EM not aware of my FT service being there, and just needs to
be told?

Thanks in advance.

Reply to this Message

Hilary Cotter - 21 Jul 2005 17:14 GMT

its MSSearch alright. What happens when you try to run SQLftwiz from the
command line?

Signature

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

> Heres some more info... if i try to run the FT wizard through Tools >
> Wizards, i get a message that says
[quoted text clipped - 8 lines]
>
> Thanks in advance.

Reply to this Message

Arthur Dent - 21 Jul 2005 17:37 GMT

sqlftwiz runs fine.
When i tried to add a column to an existing ft catalog though, it tells me
the catalog has been lost, and i need to use the SPs to recreate it.
If i try to delete the old catalog in EM, it tells me that the FT service
must
be running in order to delete a catalog, which it is, but EM cant see it.
If i use sqlftwiz to make a brand new catalog though, it works fine.

> its MSSearch alright. What happens when you try to run SQLftwiz from the
> command line?

Reply to this Message