The Content Index Service May Not Work if You Uninstall SQL Server 7.0 (225393)


The information in this article applies to:

  • Microsoft BackOffice Small Business Server 4.5
This article was previously published under Q225393
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

If you uninstall Microsoft SQL Server 7.0 from your computer running Small Business Server (SBS) 4.5, the Content Index service may not start. You may also receive the following error message:
The Dynamic Link library Query.dll could not be found in the specified path Path.
NOTE: During the uninstallation, you are prompted to keep shared files or delete them. The error message is displayed for either action.

CAUSE

This behavior occurs when one or more programs do not correctly increment the usage counters for the Qperf.dll and Query.dll files. The uninstallation process for SQL Server 7.0 removes the Query.dll and Qperf.dll files.

RESOLUTION

To resolve this problem, extract the Query.dll and Qperf.dll files from Is20.cab on SBS 4.5 CD-ROM 2:
  • Locate Is20.cab in the CD2\Ntoptpak\En\x86\Winnt.srv\ path.
  • Locate the Query.dll and Qperf.dll files and put them in the C:\Winnt.sbs\System32 folder.
  • Restart the Content Index service.

STATUS

Microsoft has confirmed that this is a problem in BackOffice Small Business Server 4.5.

MORE INFORMATION

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Before you uninstall SQL Server 7.0, you should check two registry values to make sure they are correct:
  1. Start Registry Editor (Regedt32.exe).
  2. Locate the C:\Winnt.sbs\System32\Qperf.dll value in the following registry key:

    HKEY_LOCAL_MACHINE/Software/Microsoft/Windows/CurrentVersion/SharedDlls

  3. The Data field value for Qperf.dll should be 2 or greater.
  4. Just below the Qperf.dll value is the Query.dll value.
  5. The Data field value for Query.dll should be 2 or greater. If either of these values is 1, increase the value to 2:
    1. Double-click the file name.
    2. In the Value data box, type 2.
    3. Click OK.
  6. Quit Registry Editor.
You can now uninstall SQL Server.
Modification Type:MajorLast Reviewed:8/6/2002
Keywords:kbbug KB225393
©2002 Microsoft Corporation. All rights reserved.