Re: Fullt Text Search fails in a 2 node cluster

I have opened a case with Microsoft Support. Hopefully we can clear this out.
I´l let you know how it goes.
--
SweGuy
IT Professional
Sweden


"Hilary Cotter" wrote:

does this help?

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

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"SweGuy" <SweGuy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB3CFE0A-FDB8-4DE6-ACD0-9395599AE818@xxxxxxxxxxxxxxxx
Hi!

I have a problem with Full Text Search in a clustered enviroment.
The Resource Fullt Text Search will not come online, it fails and giving
me
a error in the log that says
"An Error occurred during the online operation for instance <SQL Server
Fulltext (UTB2)>: 80070002 - the system cannot find the file specified."

I´ve tried to reinstall Full Text by reading the KB 827449, but when i get
to the part where i should use the command "ftsetup.exe" i get a error in
the
application log saying:

"Faulting application ftsetup.exe, version 2000.80.2039.0 faulting module
msvcr71.dll, version 7.10.3052.4, fault adress 0x00014d5c."
I also get a similar error concerning msvcrt.dll version 7.0.3790.1830.

We are using Windows 2003 SP1 and SQL 2000 Enterprise edition SP4

The strange about this is that right now there are 4 instances on the same
node where 2 of them has full text online and working but the 2 others has
the error mentioned above, so as i can understand there are no problem
with
the nodes but instead i believe that the instances is not aware of
Microsoft
Search. therefore as the KB article says i need to run the command
FTSETUP.EXE to configure the instances with Microsoft Search.

Right now i have no other ideas, fearing that the only thing to solve this
is to reinstall the whole SQL instance :o( wich is nothing i´m looking
forward to.

So please if you have any ideas, fill me in...
--
SweGuy
Sweden



.

Relevant Pages

  • Re: searching for apostrophes
    ... versions of SQL Server 2000, including SP4 using FREETEXT or FREETEXTTABLE. ... it will be supported by Microsoft in SQL Server 2005 ... > Hilary Cotter ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full text search and SQL Server Express
    ... I have been told my Microsoft contacts that for this question you should ... Hilary Cotter ... Looking for a SQL Server replication book? ... > that support for full text search would be added later in 2006. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: URGENT:Changing IPs on SQL cluster nodes
    ... The only problem is that the answers that microsoft had ... The only thing is now the machine is stuck in the online ... >Changing the IP Address of Network Adapters in Cluster ... >How to change the network IP addresses of SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Im having a web cast - and youre all invited
    ... This Microsoft Support WebCast discusses replication internals and provides ... transactional replication and merge replication in Microsoft SQL Server 2000 ... Hilary Cotter has been a Most Valued Professional for Microsoft SQL ...
    (microsoft.public.sqlserver.replication)
  • Critical Alert Update - W32.Slammer
    ... It's not clear if SQL Server 2000 SP1/SP2 includes the ... Microsoft SQL Desktop ... and all applications that install ... >most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)