Post reply

Full-text indexing unavailable

  • February 5, 2003 at 3:57 pm

    #64630

    Hi,

    I have few servers on NT 4.0/5.0, running SQL 7.0 (sp4), standard edition, and in EM I don't see an option for full text indexing(it's greyed out). I upgraded one server to 2000 and as I understand it's good practice to repopulate full text catalog after upgrade, but I couldn't do it since it wasn't there. I tried to install full-text indexing from CD but still no luck.

    Does anyone know what this is?

    Thanks.

  • February 10, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • February 10, 2003 at 8:04 am

    #448533

    When you view the services (Start | Run | Services.msc if you are local, alternately, Start | Run | CompMgmt.msc and expand until you get to services if you're checking from your Win 2K/XP workstation) on the server, do you see the Microsoft Search service installed and running?

    If so, did you remove the BUILTIN\Administrators account?

    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

  • February 10, 2003 at 9:26 am

    #448545

    If you did remove BUILTIN\Administrators account, you have to grant 'Nt Authority\System' account to access SQL Server with 'sa' right.

  • February 10, 2003 at 11:18 am

    #448555

    Yup. That's what I was getting at. Here's the KB article that describes the issue:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;317746

    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

  • February 10, 2003 at 12:52 pm

    #448568

    Yes, I did remove builtin\admin account. I do have Microsoft search services and they are running.

    If I add 'Nt Authority\System' account and give SA privileges to account, who exactly gets access to this server? We have few people with NT admin rights on domain and we would like to keep them off the SQL server(atleast not SA privileges)

    Thanks for bringing this post back up and responding. I had almost lost hopes on this.

  • February 10, 2003 at 1:17 pm

    #448571

    It is 'local system account' to run Microsoft Search service that has to access SQL Server.

    As long as you remove 'BUILTIN\Administrators' from SQL Server logins, Those people with NT domain admin right will not be able to access your SQL Server as 'sa' unless you assign them to access SQL Server individually.

  • February 11, 2003 at 9:50 am

    #448650

    I don't get this. I added

    'Nt Authority\System' account and gave SA priv. to this account. Microsfot search service is up and running under local system account. Still no change. Does SQL server need to be restarted for this?

    Thanks.

  • February 11, 2003 at 9:53 am

    #448651

    I don't remember whether machine has to be restarted. Try to restart MSSearch and SQL Server services.

  • February 12, 2003 at 11:04 pm

    #448835

    MSSearch should be running with the same account as SQL Server.

    Also check out this link

    http://dbforums.com/arch/72/2003/1/643358

    Cheers

    -¢ödêmån-


    -¢ödêmån-

  • February 13, 2003 at 8:18 am

    #448864

    Don't think you can change the service account from local system account to anyone else.

  • February 13, 2003 at 8:49 am

    #448871

    Actually, Full-Text is supposed to run under localsystem. Configurations of full-text other than this aren't supported:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;295034

    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

  • February 13, 2003 at 12:24 pm

    #448913

    Thanks everyone for your response.

    This is what I am at now.

    I don't have builtin/admin account in SQl logins.

    I added NT authority/system account in sql logins and gave sysadmin rights.

    Microsoft search service is running under local system account.

    Sill full text indexing is greyed out in EM.!!May be I am doing something wrong.

    But anyway how important is it to repopulate full text catalog after you upgrade to 2000?

    Thanks.

  • February 13, 2003 at 1:27 pm

    #448920

    Try to add "BUILTIN\Administrators" back to your SQL Server logins with 'sa' right.

    Edited by - Allen_Cui on 02/13/2003 1:27:38 PM

  • February 16, 2003 at 3:45 pm

    #449070

    Allen,

    Tried that too. Didn't work.

    Thanks.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply