Category Assistant Is Disabled After You Remove SQL Server 7.0 SP2 (287293)


The information in this article applies to:

  • Microsoft SharePoint Portal Server 2001
This article was previously published under Q287293

SYMPTOMS

If you install Microsoft SQL Server 7.0 Service Pack 2 (SP2) on a computer that has the SharePoint Portal Server client components installed, and then you remove SQL Server, the Category Assistant may be disabled after you remove the program. In addition, you may no longer be able to use the content source administration functionality.

CAUSE

This issue can occur because the Microsoft Search (MSSearch) service is shared among programs such as SharePoint Portal Server and SQL Server. When you remove SQL Server, the dynamic-link library (.dll) files that MSSearch uses are unregistered.

RESOLUTION

To resolve this issue, reregister Mssitlb.dll and Srchadm.dll:
  1. Click Start, click Run, and then type the following commands:
    • regsvr32 "Drive_letter:\program files\common files\microsoft shared\mssearch\common\mssitlb.dll"
    • regsvr32 "Drive_letter:\program files\common files\microsoft shared\mssearch\bin\srchadm.dll"
  2. Press ENTER after you type each command.
Modification Type:MinorLast Reviewed:4/25/2005
Keywords:kbprb KB287293
©2004 Microsoft Corporation. All rights reserved.