May 13, 2003 at 2:12 pm
We have a two node cluster with full text enabled for some of our databases. It seems that when we fail over to the second node full text functionality breaks. The nodes were setup identical and I cannot determine what is causing the problem. When I launch the SQL Server installation to try and add the component I am only presented with the option to uninstall my installation. Is there a manual process that I must follow to install Full Text on the second node?
Thanks!
Thats Bigman 2 Y-O-U!
May 13, 2003 at 2:35 pm
quote:
It seems that when we fail over to the second node full text functionality breaks.
SQL Server FullText is a cluster resource that should be able to failed over on both nodes. Can you bring it online manually?
What error mesages did you received in both SQL Server errorlogs and machine application/system logs?
Check mssearch service is up or not on that failed node.
What are your SQL Server version and service pack?
Edited by - Allen_Cui on 05/13/2003 2:36:27 PM
May 13, 2003 at 3:23 pm
Verify that the Microsoft Search service is running under the LocalSystem context as well on both nodes.
Is this an active/passive or active/active cluster?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 13, 2003 at 5:43 pm
Active/Passive cluster
MS Search is up and running with the same account as the other SQL Services -- both nodes. We are run ning SP3 on both nodes for SQL and SP3 for 2K.
The errors that I see are from the SQL Agent not being able to start the Full Text indexing on the jobs that are scheduled. Thanks!
Edited by - bigman2u on 05/13/2003 5:45:04 PM
Thats Bigman 2 Y-O-U!
May 13, 2003 at 7:34 pm
Can you post the error messages here? Make sure all SQL Server resources are online from Cluster Administrator.
What service account SQL Server and Agent services run? Has 'BUILTIN\Administrators' login been removed from SQL Server login?
Full Text does not work properly after sp3 upgrade SQL Server 2000 (upgrading to SP3) where SQL Server 7.0 (with Full-Text Search installed) exists or previously existed.
Edited by - Allen_Cui on 05/13/2003 7:41:42 PM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply