Post reply

fulltext catalog problem

  • December 29, 2004 at 8:30 am

    #84494

    I'm trying to create a full text catalog on our production server but the sp_fulltext_database sp keeps coming back with the error message 'the directory name is invalid'.

    I've tried changing directories, access rights etc. but nothing seems to help.

    Any suggestions?

    Thanks.

     

  • December 30, 2004 at 12:41 am

    #535370

    Yes, What is the <value> for the following registry key on the server where this problem exists?

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<named_instance>\MSSQLServer

     FullTextDefaultPath=  <value>

    Do you get the same error if you specify a specific path for your new FT Catalog name <Cat_Address>?

    There should be no invisible or un-printable characters in the above <value> for FullTextDefaultPath. Could you use Regedit and delete the current string and re-enter it? In the past I've had customer's who had un-printable (un-viewable) characters in this Registry key value cause similar problems...

    Do you have permissions on that path? Has the service account changed for the "Microsoft Search" (MSSearch.exe) service? Is it running under the "System account" (localsystem)?

    Finally, what is the full output of -- SELECT @@version -- as this can be helpful for troubleshooting SQL FTS issues.

    Thanks,

    John

    SQL Full Text Search Blog

    http://spaces.msn.com/members/jtkane/


    John T. Kane

  • December 30, 2004 at 1:58 am

    #535374

    John,

    Thanks for your reply.

    The FullTextDefaultPath regkey value does not contain any un-printable characters though the location of the key was in a different place ( HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer), this is also the case on our dev. server so I assume this is correct.

    I get the same error whatever path I specify.

    The MSSearch Service runs under Local System.

    The value of @@version is :

    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)

     Dec 17 2002 14:22:05

     Copyright (c) 1988-2003 Microsoft Corporation

     Standard Edition on Windows NT 5.2 (Build 3790: )

    Thanks,

    Rene

     

     

     

  • January 9, 2005 at 11:16 pm

    #536597

    Hi,

    Sorry, for the late reply... I've reviewed all past fulltext newsgroup replies where the poster have gotten this error and in all cases the only solution was to re-install the Full Text Search compoents, either via the procdures in the following KB article:

    827449 How to manually reinstall the Microsoft Search service for an instance of SQL 2000

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449

    Regards,

    John

    SQL Full Text Search Blog

    http://spaces.msn.com/members/jtkane/


    John T. Kane

  • January 13, 2005 at 12:23 am

    #537190

    John,

    Thanks for the reply, reinstalling MSSearch did the trick.

     

    Regards Rene.

     

  • February 12, 2005 at 11:58 pm

    #541954

    I also had this problem.

    However I simply stopped the MS Search service and started it again and the problem was fixed - no re-install was necessary. I was able to create a catalog without the "Invalid Directory" error message.

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

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