 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / June 2004Full Text Service not starting from EM
hello, I have the following problem. Everything was working fine with the full text search. I created a catalog etc... now in EM, database->tools->"Full Text Indexing" is grayed out. I cannot use the full text indexing with tables (grayed out) and the full text search is marked as stopped in the support services. Trying to start it returns a "an instance of the service is already running" error. The Microsoft search service is started however. I am also able to run queries using the full text indexes I have created, so it seems only the administration from EM is not working. any idea would be greatly appreciated thank you Benoit Benoit, You should checkout the following 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 this should explain the problem you are experiencing. Regards, John > hello, > [quoted text clipped - 16 lines] > > Benoit John thank you for your reply... The instance of the SLQ server 2000 is running on my computer under the localsystem account. I am connecting with EM on my computer running the service, not from another client computer. in EM the local server is registered with Windows Authentication. Isnt there a way for me to administer Full Text Search from EM under these conditions? Seems like the most straightforward configuration to me. thanks again Benoit >-----Original Message----- >Benoit, [quoted text clipped - 28 lines] > >. You're welcome, Benoit, If you are using the (system) LocalSystem account to start & run the MSSQLServer service, then it should work. This is the exact configuration I'm using on my home server and it works for me. Can you re-confirm that you are not using a local machine account, check the EM server property security tab and "system account" should be marked. Can you use the system stored procedures to create and populate FT Catalogs on this server, (see SQL 2000 BOL for examples of use): a.. sp_fulltext_database -- Initializes full-text indexing or removes all full-text catalogs from the current database. a.. sp_fulltext_catalog -- Creates and drops a full-text catalog. a.. sp_fulltext_table -- Marks or unmarks a table for full-text indexing. a.. sp_fulltext_column -- Adds columns to full-text indexes. Regards, John > John thank you for your reply... > [quoted text clipped - 55 lines] > > > >. I find sometimes you have to right click on your SQL FTS catalog in EM, and refresh it. Sometimes through a combination of manipulating your catalogs you can enable your Full Text menus.  SignatureHilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html > You're welcome, Benoit, > If you are using the (system) LocalSystem account to start & run the [quoted text clipped - 73 lines] > > > > > >. hello, thank you both for your help. the system stored procedures are working fine to create/populate catalogs but my menus are still disabled. I have another computer with the exact same configuration and all the menus are enabled. Ive seen others users report the same bug but with no answer. Guess Ill stick to the system stored procedures. Thanks again Benoit >-----Original Message----- >I find sometimes you have to right click on your SQL FTS catalog in EM, and [quoted text clipped - 83 lines] > >. Benoit, A couple of additional questions... Are you accessing the server with this problem via the internet using the EM? Also, how have you registered this server in the EM via the server name, as an IP address or as a server alias? If you're using either an IP address or a server alias, could you delete and re-register the server with the true server's name? and then re-test the FT-enabled table's properties and confirm if the FT menus are still grayed out. Thanks, John > hello, > [quoted text clipped - 116 lines] > > > >. I ran into this as well. I had my SQL Server registered in EM as (local). I deleted the registration, and re-registered it as the server name and everything worked. Brien King > hello, > [quoted text clipped - 16 lines] > > Benoit |
Reply to this Message |
 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.