Post reply

Full Text Indexing option greyed out

  • September 9, 2004 at 8:50 am

    #83970

    SQL Server 2000 Std

    Windows 2000 Server

    I can create full text catalogues from the server but Full text Indexing option is greyed out on the client machines (win NT4.0 workstation)

    Thanks

  • September 9, 2004 at 1:37 pm

    #522383

    It seems dumb question but are you using the same account? like 'sa'?

     

  • September 10, 2004 at 4:59 am

    #522509

    Different accounts,  but both had sysadmin permissions.  

  • September 10, 2004 at 9:18 am

    #522572

    Another dump question that might be..

    Can you try to use 'sa' from NT workstation to see if you get the option back? Just trying to isolate the permission problem..

     

  • September 10, 2004 at 11:11 am

    #522601

    Is this SQL Server 7.0 or SQL Server 2000 on NT 4.0 Workstation and what Edition of SQL Server? Could you post the output of SELECT @@version -- as this is most helpful in troubleshooting SQL FTS issues.

    Since this is NT4.0 Workstation, and depending upon your SQL Server version & edition, the SQL Full-text Search (FTS) components may not be supported on this OS platform version... Or the issue may be related to permissions and how you have the MSSQLServer services account started, see KB Article Q270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local Windows NT Accounts

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

    Thanks,


    John T. Kane

  • September 13, 2004 at 7:12 am

    #522725

    Tried logging on as 'sa', same result,

    version : SQL Server 2000 standard  - 8.00.760

    I am inclined to think it a Win NT4.0 workstation issue. I just need someone to confirm if possible

    Thanks 

  • September 13, 2004 at 10:35 am

    #522799

    Yes, I believe that it is a Win NT4.0 Workstation, the emphis on Workstation that is a simalar OS version as Win XP Professional. On the latter, you need SQL Server 2000 Developer Edition and then use "Custom Installation" and select "Full-text Search" under the Server components. You might want to try the same on your Win NT4.0 Workstation, assuming that you're using the Developer Edition of SQL Server 2000.

    Regards,


    John T. Kane

Viewing 7 posts - 1 through 6 (of 6 total)

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