Monday, March 26, 2012

How to reinstall?

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.
http://support.microsoft.com/default...b;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
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:O7P0WgNjFHA.3256@.TK2MSFTNGP12.phx.gbl...
> 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.
>
|||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.
|||You may be running into this problem.
http://support.microsoft.com/default...b;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
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:e6UNCVajFHA.3960@.TK2MSFTNGP12.phx.gbl...
> 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.
>
|||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.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OLAUvdjFHA.2852@.TK2MSFTNGP14.phx.gbl...
> You may be running into this problem.
> http://support.microsoft.com/default...b;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
> "Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:e6UNCVajFHA.3960@.TK2MSFTNGP12.phx.gbl...
>
|||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.
|||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
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:%23bMwM4fjFHA.1048@.tk2msftngp13.phx.gbl...
> 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.
>
|||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.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ORIFA9gjFHA.2920@.TK2MSFTNGP14.phx.gbl...
> 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

No comments:

Post a Comment