all groups > sql server full text search > july 2005 >
You're in the

sql server full text search

group:

How to reinstall?


How to reinstall? Arthur Dent
7/19/2005 11:06:55 PM
sql server full text search:
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.

Re: How to reinstall? Hilary Cotter
7/20/2005 5:40:40 AM
http://support.microsoft.com/default.aspx?scid=kb;en-us;827449

--
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
[quoted text, click to view]

Re: How to reinstall? Arthur Dent
7/20/2005 11:35:35 PM
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.

Re: How to reinstall? Hilary Cotter
7/21/2005 6:06:09 AM
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

--
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
[quoted text, click to view]

Re: How to reinstall? Arthur Dent
7/21/2005 10:02:52 AM
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.



[quoted text, click to view]

Re: How to reinstall? Arthur Dent
7/21/2005 10:11:10 AM
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.

Re: How to reinstall? Hilary Cotter
7/21/2005 12:14:17 PM
its MSSearch alright. What happens when you try to run SQLftwiz from the
command line?

--
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
[quoted text, click to view]

Re: How to reinstall? Arthur Dent
7/21/2005 12:37:40 PM
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.



[quoted text, click to view]

AddThis Social Bookmark Button