Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / October 2005

Tip: Looking for answers? Try searching our database.

Owner missing in Cluster

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tim - 26 Oct 2005 18:48 GMT
When I look at properties for FT in cluster administrator the only owner I
see is the node1 owner.  Why doesn't owner node2 show up as a selection?
I'm thinking about doing the following below from a MS KB article to fix my
problem, any ideas?

----------------------------------------------------------------------------
--------------

You can reinstall the Full Text resource by manually running Ftsetup.exe.
However, before you can manually run Ftsetup.exe, you must perform the
following cleanup steps.

Note You must perform these cleanup steps on all nodes in the cluster group.

1. Delete the NewInstanceName subkey under the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gathering

Manager\Applications

2. Delete the NewInstanceName subkey under the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications

3. Locate the shared data directory of the new clustered instance, and then
delete everything under the FTData folder.

Note Typically, the FTData folder includes some .0 files, some .1 files, and
a SQLServer$NewInstanceName folder.

After you have completed the cleanup steps, you can reinstall the Full Text
resource.

Note Make sure that you only run Ftsetup.exe from the node from which you
originally ran the SQL Server Setup program. Also, make sure that the node
has control of the shared drive.

To manually run Ftsetup.exe, you can use the following command-line

command:

"Path of the new clustered instance Bin folder\ftsetup.exe"

SQLServer$InstanceName SQL Server Account 1 0 1 0

Note InstanceName is the name of the new clustered instance of SQL Server.
SQL Server Account is the account under which SQL Server runs.

This account must have local administrator permissions on the node from
which you run Ftsetup.exe.
John Kane - 27 Oct 2005 03:33 GMT
Tim,
Before you attempt re-installing the FT Search resource via the steps in KB
article 899580 "Full Text resource fails when you install a new clustered
instance after you apply SQL2K SP3 to an existing clustered instance" at
http://support.microsoft.com/default.aspx?scid=kb;en-us;899580, what do you
see when you failover to the 2nd node (node2)?

As I don't have a clustered server at home <G>, you may want to call in to
PSS Microsoft SQL Server support and open a support case, as cluster issues
can be troublesome...

Regards,
John
Signature

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

> When I look at properties for FT in cluster administrator the only owner I
> see is the node1 owner.  Why doesn't owner node2 show up as a selection?
[quoted text clipped - 51 lines]
> This account must have local administrator permissions on the node from
> which you run Ftsetup.exe.
Tim - 27 Oct 2005 16:16 GMT
Since FTS only has owner of node1 it will not failover to node2, error
message is 'An error occured when attempting to move the SQL Group Group. A
node is not availible for this resource'

> Tim,
> Before you attempt re-installing the FT Search resource via the steps in KB
[quoted text clipped - 64 lines]
> > This account must have local administrator permissions on the node from
> > which you run Ftsetup.exe.
Hilary Cotter - 28 Oct 2005 02:20 GMT
Sounds like SQL FTS is not installed correctly on the second node. Evict the
second node, remove SQL from this node, and then reinstall it.

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

> Since FTS only has owner of node1 it will not failover to node2, error
> message is 'An error occured when attempting to move the SQL Group Group. A
[quoted text clipped - 77 lines]
> > > This account must have local administrator permissions on the node from
> > > which you run Ftsetup.exe.
Tim - 28 Oct 2005 22:36 GMT
By evicting the 2nd node and uninstalling/reinstalling sql then rejoining
will it break anything?  We also have IIS clustered, MSDTC, etc...  Is there
a good web site we can refer to, step-by-step instructions for the above
method?

> Sounds like SQL FTS is not installed correctly on the second node. Evict the
> second node, remove SQL from this node, and then reinstall it.
[quoted text clipped - 88 lines]
> from
> > > > which you run Ftsetup.exe.
Hilary Cotter - 30 Oct 2005 11:53 GMT
It appears as if your second node is hosed - or the fts part of it is. By
following the sequence I recommended it should rejoin file. I suggest
however that you post to the clustering newsgroup for clarification on what
the best way to proceed is.

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

> By evicting the 2nd node and uninstalling/reinstalling sql then rejoining
> will it break anything?  We also have IIS clustered, MSDTC, etc...  Is there
[quoted text clipped - 20 lines]
> at
> > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;899580, what

> do
> > > you
[quoted text clipped - 83 lines]
> > from
> > > > > which you run Ftsetup.exe.
John Kane - 28 Oct 2005 04:46 GMT
Tim,
What errors (if any) are reported in the Cluster log? Additionally, review
the server's application event log for both "Microsoft Search" and MssCi
source events (warnings and errors), and let me know if you have any errors
with the following text: "80070002 - The system cannot find the file
specified".

Thanks,
John
Signature

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

> Since FTS only has owner of node1 it will not failover to node2, error
> message is 'An error occured when attempting to move the SQL Group Group.
[quoted text clipped - 83 lines]
>> > This account must have local administrator permissions on the node from
>> > which you run Ftsetup.exe.
Hilary Cotter - 27 Oct 2005 11:46 GMT
What happens when you failover to the other node? The owner name should
change? Is this a multi-instance cluster?

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

> When I look at properties for FT in cluster administrator the only owner I
> see is the node1 owner.  Why doesn't owner node2 show up as a selection?
[quoted text clipped - 46 lines]
> This account must have local administrator permissions on the node from
> which you run Ftsetup.exe.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.