|
|
You're in the
sql server full text search
group:Adding Full-Text Search Indexing to a Cluster
sql server full text search:
article or provide the steps for adding Full-text indexing? I can't seem to find one! Thank you. Jay
Jay,
Could you post the full output of -- SELECT @@version -- as this is helpful in understanding your current clustered environment. For the time being, I'm going to assume that you have a clustered SQL Server 2000 A/P environment. Correct? If so, then you should be using SQL Server 2000 Enterprise Edition and Full-text Indexing (and Full-text Search, often referred to as SQL FTS) is installed by default. You can use the SQL Enterprise Manager and select Server and database, you want to FT-enable and click on Tools -> Full-text Indexing to launch the FT Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all the necessary steps for adding Full-text Indexing to a selected table. Note, the table, must have a single column, non-nullable, unique index to qualify for a table to be FT Indexed. Also, the only restriction for FTI in a clustered environment, is that the FT Catalog, must be created on the shared disk drive in your clustered environment. You may also want to do this via pure T-SQL code, and if so, checkout "Full Text Indexing using T-SQL from a Profiler Trace" at http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry and this blog entry will walk you though all the necessary T-SQL code. Hope that helps! John -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] <jay.griffin@burke.com> wrote in message news:1107212619.013634.8160@c13g2000cwb.googlegroups.com... > Ihave an Active/Passive Cluster. Can someone point me to a Technet > article or provide the steps for adding Full-text indexing? > I can't seem to find one! > > Thank you. > Jay >
SQL FTS has to be installed from the start on a cluster. The SQL Server 2000
High availablilty book is pretty good for installing a cluster. [quoted text, click to view] <jay.griffin@burke.com> wrote in message news:1107212619.013634.8160@c13g2000cwb.googlegroups.com... > Ihave an Active/Passive Cluster. Can someone point me to a Technet > article or provide the steps for adding Full-text indexing? > I can't seem to find one! > > Thank you. > Jay >
Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000
Adv Server. Sorry to omit that important information. Here is my problem -- Full Text indexing is not installed. When I try to do what you indicated, Full Text Indexing is grayed out. I was installing some other software which was going to create a database. It gave the a warning that Full text indexing was not installed and the software would not function properly. If I go into the SQL Setup, I can't add/remove components. The only option I have is to Uninstall. I am wondering how I can add full-text indexing. Thanks for your help, Jay [quoted text, click to view] John Kane wrote:
> Jay, > Could you post the full output of -- SELECT @@version -- as this is helpful > in understanding your current clustered environment. > > For the time being, I'm going to assume that you have a clustered SQL Server > 2000 A/P environment. Correct? If so, then you should be using SQL Server > 2000 Enterprise Edition and Full-text Indexing (and Full-text Search, often > referred to as SQL FTS) is installed by default. > > You can use the SQL Enterprise Manager and select Server and database, you > want to FT-enable and click on Tools -> Full-text Indexing to launch the FT > Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all the > necessary steps for adding Full-text Indexing to a selected table. Note, the > table, must have a single column, non-nullable, unique index to qualify for > a table to be FT Indexed. Also, the only restriction for FTI in a clustered > environment, is that the FT Catalog, must be created on the shared disk > drive in your clustered environment. > > You may also want to do this via pure T-SQL code, and if so, checkout "Full > Text Indexing using T-SQL from a Profiler Trace" at > http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry > and this blog entry will walk you though all the necessary T-SQL code. > > Hope that helps! > John > -- > SQL Full Text Search Blog > http://spaces.msn.com/members/jtkane/ > > > > <jay.griffin@burke.com> wrote in message > news:1107212619.013634.8160@c13g2000cwb.googlegroups.com... > > Ihave an Active/Passive Cluster. Can someone point me to a Technet > > article or provide the steps for adding Full-text indexing? > > I can't seem to find one! > > > > Thank you. > > Jay > >
You're welcome, Jay,
Despite what you see as "Full Text Indexing is grayed out", it is most likely that Full Text Search (FTS) is installed because of what you see when you attempt to add the "Full-Text Search" components via SQL Setup and "custom installation" where the "Full-Text Search" component option is already checkmarked. Correct? If the above is not correct, you may have the MSSQLServer service running under a local machine account, if so, then checkout KB article Q270671 (Q270671) "PRB: Full Text Search Menus Are Not Enabled for Local Windows NT Accounts" at: http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671 If the above is correct, then you can force the removal of the checkmark via the removal or renaming of the following tracking registry key and the following procedure to Re-install" the "Full-text Search" components via deleting (or renaming) the below "tracking key" and re-install (If you're not using a named instance, remove "<Instance_Name>\".) NOTE: be sure to be logged on to the server as either Administrator or as a member of the server's Admin Group! HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance_Name>\Tracking\ {E07FDDA7-5A21-11d2-9DAD-00C04F79D434} Once you're done removed (renamed) the above tracking key, then delete the MSSearch directory from either: drive_letter:\Program Files\Common Files\Microsoft Shared\ or drive_letter::\Program Files\Common Files\System\ Then using your SQL Server 2000 installation CD re-install via "Custom Installation" the Full-Text Search component (it should be un-checked). When this completes find and save these files: SearchSetup.log (usually under \windows or \winnt folders) and sqlsp.log. If any problems, please post these files. Re-install the service pack that you may have applied to SQL Server 2000, so that the newly re-installed MSSearch components are upgraded to SP3a levels and then re-boot &/or restart the MSSearch and MSSQLServer services. You may also want to consult or perform the procedures document in the following Kb article: 827449 "How to manually reinstall the Microsoft Search service for an instance of SQL 2000" at: http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 Finally, and considering that this is a clustered environment, you may also want to review the following KB articles: 812666 "How to recover a failed full-text search resource on a clustered instance of SQL Server 2000" at: http://support.microsoft.com/default.aspx?kbid=812666 "The full-text search results that are returned in a clustered SQL Server 2000 environment may be different when the active node changes" at: http://support.microsoft.com/default.aspx?scid=kb;en-us;889708 Hope that helps! John -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] <jay.griffin@burke.com> wrote in message news:1107270434.064396.309410@c13g2000cwb.googlegroups.com... > Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000 > Adv Server. Sorry to omit that important information. > > Here is my problem -- Full Text indexing is not installed. When I try > to do what you indicated, Full Text Indexing is grayed out. > > I was installing some other software which was going to create a > database. It gave the a warning that Full text indexing was not > installed and the software would not function properly. > > If I go into the SQL Setup, I can't add/remove components. The only > option I have is to Uninstall. I am wondering how I can add full-text > indexing. > > Thanks for your help, > Jay > > > John Kane wrote: > > Jay, > > Could you post the full output of -- SELECT @@version -- as this is > helpful > > in understanding your current clustered environment. > > > > For the time being, I'm going to assume that you have a clustered SQL > Server > > 2000 A/P environment. Correct? If so, then you should be using SQL > Server > > 2000 Enterprise Edition and Full-text Indexing (and Full-text Search, > often > > referred to as SQL FTS) is installed by default. > > > > You can use the SQL Enterprise Manager and select Server and > database, you > > want to FT-enable and click on Tools -> Full-text Indexing to launch > the FT > > Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all > the > > necessary steps for adding Full-text Indexing to a selected table. > Note, the > > table, must have a single column, non-nullable, unique index to > qualify for > > a table to be FT Indexed. Also, the only restriction for FTI in a > clustered > > environment, is that the FT Catalog, must be created on the shared > disk > > drive in your clustered environment. > > > > You may also want to do this via pure T-SQL code, and if so, checkout > "Full > > Text Indexing using T-SQL from a Profiler Trace" at > > > http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry > > and this blog entry will walk you though all the necessary T-SQL > code. > > > > Hope that helps! > > John > > -- > > SQL Full Text Search Blog > > http://spaces.msn.com/members/jtkane/ > > > > > > > > <jay.griffin@burke.com> wrote in message > > news:1107212619.013634.8160@c13g2000cwb.googlegroups.com... > > > Ihave an Active/Passive Cluster. Can someone point me to a Technet > > > article or provide the steps for adding Full-text indexing? > > > I can't seem to find one! > > > > > > Thank you. > > > Jay > > > >
Thanks John.
Clarification from my previous post: "If I go into the SQL Setup, I can't add/remove components. =ADThe only option I have is to Uninstall. " -- ALL other options are grayed out. It is not a matter of them already being checked. I have no option to check them. It isn't installed and it won't let me add it. I am assuming because this is a cluster, components have to be added differently. Because I have no option to add/remove components under the custom install. My only option is to Uninstall. (yes - I am logged in as administrator). MSSQLServer is running as a domain account and that account is in the domain admins group.
You're welcome, Jay,
Ok, so we take 10 yards and punt (to use a football analogy)... Before I ask you to un-cluster your servers and re-install SQL Server (a big effort, I know), I want you to confirm something for me. Is this SQL Server installed on a Domain Controller or a backup DC? As I've seen problems with FTS working correctly when installed on a DC or BDC and with MSSQLServer service startup account being the Domain Administrators account. If it's not on a DC or BDC, but you are using an account that is a member of the DOMAIN Administrator group, could you create a separate DOMAIN\Account and add that account to the local server's Administrators Group and then using the SQL Enterprise Manager's server property security tab, change the MSSQLServer service startup account to the newly created DOMAIN\Account. This change should prompt you to stop & re-start SQL Server and click yes to this prompt. Then close and re-launch the Enterprise Manager and see if the Full Text Indexing is still grayed out. If it is not grayed out, then failover to your Passive node and do the same thing there. As I've said I've seen this before in non-clustered environments where SQL Server 2000 was installed on a DC or BDC and the MSSQLServer service startup account being the Domain Administrators account. The solution in this case was as I described above or resetting the MSSQLServer service startup account use LocalSystem or as a last resort move the SQL Server off the DC or BDC. Let me know if this successful for you, otherwise, the fallback solution is to un-cluster your servers and re-install SQL Server :-( Thanks, John -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] <jay.griffin@burke.com> wrote in message Thanks John.news:1107277007.739900.246620@z14g2000cwz.googlegroups.com... Clarification from my previous post: "If I go into the SQL Setup, I can't add/remove components. The only option I have is to Uninstall. " -- ALL other options are grayed out. It is not a matter of them already being checked. I have no option to check them. It isn't installed and it won't let me add it. I am assuming because this is a cluster, components have to be added differently. Because I have no option to add/remove components under the custom install. My only option is to Uninstall. (yes - I am logged in as administrator). MSSQLServer is running as a domain account and that account is in the domain admins group.
Based on what you are telling me -- I am going to have to uncluster and
re-install. The servers are not a DC. The special user I setup for the SQL servers is in the local admins group already. Do you know of any KB articles that would walk me through this without losing any information?
Jay,
Yep, 10 yards & punt... Re-installing a Clustered SQL server is never easy, but these references may help: a.. SQL Server 2000 Clustering Whitepaper, http://www.microsoft.com/SQL/techinfo/administration/2000/failovercluster.asp a.. 815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server http://support.microsoft.com/?id=815431 a.. 325485 WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup http://support.microsoft.com/?id=325485 a.. 274446 INF: Upgrade to SQL Server 2000 Failover Solution Recommended for All.... http://support.microsoft.com/?id=274446 a.. 254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings http://support.microsoft.com/?id=254321 a.. 243218 INF: Installation Order for SQL Server 2000 Enterprise Edition http://support.microsoft.com/?id=243218 a.. 260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering http://support.microsoft.com/?id=260758 Hope this helps! John -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] <jay.griffin@burke.com> wrote in message news:1107354007.277719.324960@g14g2000cwa.googlegroups.com... > Based on what you are telling me -- I am going to have to uncluster and > re-install. The servers are not a DC. The special user I setup for > the SQL servers is in the local admins group already. > > Do you know of any KB articles that would walk me through this without > losing any information? >
John,
Thank you for all your help on this issue. Jay
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |