|
|
You're in the
sql server full text search
group:Full-Text Menu Disabled
sql server full text search:
environment with 286 active databases. It has recently come to our attention that the "Full-Text Indexing..." menu option has become unavailable (grayed out) to anyone who tries to access this option via Enterprise Manager, this of course is affecting some of our clients. I have done a lot of Google searching as well as hit the MS Technet site without any luck. If you have experienced this situation before, how have you resolved it? The Microsoft Search Service (MSSEARCH) is running as LocalSystem and is installed and running. This can be verified because existing Full-Text Catalogs created previous to the above mentioned continue to function without error. Another thing to mention would be that new catalogs and the maintenance options such as rebulding or performing incremental updates work without error when executed within Query Analyzer. Although the error is not the same, a supporting article of this can be found via the URL http://support.microsoft.com/default.aspx?scid=KB;en- us;q270671 within the "CAUSE" section. Below is some information that may be needed to determine a possible solution to my situation: SELECT fulltextserviceproperty('IsFulltextInstalled') = 1 (MSSearch is installed) SELECT @@VERSION Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) The system recently went through a NTFS password change on the Administrator account as well as the SQL Server SA account. The system has all Critical Updates installed and has been rebooted. It is not definite whether this problem occured before or after the recent password changes. Thank you in advance for your help.
Edwin,
There may be more than one issue at work here.. It is interesting that you indicate that new catalogs and the maintenance options such as rebuilding or performing incremental updates work without error when executed within Query Analyzer, as this is the primary solution/workaround to FTS menu options being grayed out in KB article Q270671. However, there is another scenario and that is when your customers register the server using an IP address (for example, 12.233.106.98) in their SQL Server Enterprise Manager (EM) and access the problem SQL Server via the internet as under these conditions, the Enterprise Manage cannot "see" or recognize that the MSSearch service (or even SQLServerAgent service for that matter) is running. However, the services are running and functional, it's just that the EM cannot see these services. Additionally, and as you're running SQL 2000 SP3a (build 818) Std. Edition on Win2K SP4, you may of hit the bug documented in KB article 814035 (Q814035) "FIX: A Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3" at: http://support.microsoft.com/default.aspx?scid=kb;en-us;814035, but it's doubtful as you can successfully create new FT catalogs and populate them. It is also possible that because of recent NTFS password change on the Administrator account, that you hit this KB article 277549 (Q277549) "PRB: Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component Services]" at http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549 , but this too is doubtful because of the same reasons. Basically, if your customers must register their servers using IP address and access your server via the internet (a requirement, I suspect for a ISP), then it will be necessary for your customers to use T-SQL code to workaround this issue. If you want I can provide you with easily implemented T-SQL code examples. Regards, John [quoted text, click to view] "Edwin" <edwin.velez@hostcentric.com> wrote in message news:043f01c3c562$9c13dc40$a001280a@phx.gbl... > I have a copy of MSSQL 2000 running in a shared hosting > environment with 286 active databases. It has recently > come to our attention that the "Full-Text Indexing..." > menu option has become unavailable (grayed out) to anyone > who tries to access this option via Enterprise Manager, > this of course is affecting some of our clients. > > I have done a lot of Google searching as well as hit the > MS Technet site without any luck. If you have experienced > this situation before, how have you resolved it? > > The Microsoft Search Service (MSSEARCH) is running as > LocalSystem and is installed and running. This can be > verified because existing Full-Text Catalogs created > previous to the above mentioned continue to > function without error. > > Another thing to mention would be that new catalogs and the > maintenance options such as rebulding or performing > incremental updates work without error when executed > within Query Analyzer. Although the error is not the same, > a supporting article of this can be found via the URL > http://support.microsoft.com/default.aspx?scid=KB;en- > us;q270671 within the "CAUSE" section. > > Below is some information that may be needed to determine > a possible solution to my situation: > > SELECT fulltextserviceproperty('IsFulltextInstalled') = 1 > (MSSearch is installed) > > SELECT @@VERSION > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) > May 31 2003 16:08:15 > Copyright (c) 1988-2003 Microsoft Corporation > Standard Edition on Windows NT 5.0 (Build 2195: Service > Pack 4) > > The system recently went through a NTFS password change on > the Administrator account as well as the SQL Server SA > account. The system has all Critical Updates installed > and has been rebooted. It is not definite whether this > problem occured before or after the recent password > changes. > > Thank you in advance for your help. > > Edwin
http://support.microsoft.com/?id=270671
[quoted text, click to view] "Edwin" <edwin.velez@hostcentric.com> wrote in message news:043f01c3c562$9c13dc40$a001280a@phx.gbl... > I have a copy of MSSQL 2000 running in a shared hosting > environment with 286 active databases. It has recently > come to our attention that the "Full-Text Indexing..." > menu option has become unavailable (grayed out) to anyone > who tries to access this option via Enterprise Manager, > this of course is affecting some of our clients. > > I have done a lot of Google searching as well as hit the > MS Technet site without any luck. If you have experienced > this situation before, how have you resolved it? > > The Microsoft Search Service (MSSEARCH) is running as > LocalSystem and is installed and running. This can be > verified because existing Full-Text Catalogs created > previous to the above mentioned continue to > function without error. > > Another thing to mention would be that new catalogs and the > maintenance options such as rebulding or performing > incremental updates work without error when executed > within Query Analyzer. Although the error is not the same, > a supporting article of this can be found via the URL > http://support.microsoft.com/default.aspx?scid=KB;en- > us;q270671 within the "CAUSE" section. > > Below is some information that may be needed to determine > a possible solution to my situation: > > SELECT fulltextserviceproperty('IsFulltextInstalled') = 1 > (MSSearch is installed) > > SELECT @@VERSION > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) > May 31 2003 16:08:15 > Copyright (c) 1988-2003 Microsoft Corporation > Standard Edition on Windows NT 5.0 (Build 2195: Service > Pack 4) > > The system recently went through a NTFS password change on > the Administrator account as well as the SQL Server SA > account. The system has all Critical Updates installed > and has been rebooted. It is not definite whether this > problem occured before or after the recent password > changes. > > Thank you in advance for your help. > > Edwin
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 |