Allow Web Proxy Service to Wait for SQL Service Before Logging

Last reviewed: December 30, 1997
Article ID: Q174787

The information in this article applies to:

  • Microsoft Proxy Server versions 1.0 and 2.0

SYMPTOMS

If you select (enable) logging and set up to go to a SQL Server database for the Web Proxy Service, sometimes upon rebooting, the service set up to use the SQL Server database will fail to log anymore.

CAUSE

This happens because the Web Proxy service relies on the SQL Server service to be started before that service can begin logging. If the Proxy service starts before the SQL Server service, it will not be able to log and the service will turn logging off.

NOTE: This is also true of the WWW service.

RESOLUTION

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

For these services to use SQL Server as a logging source, you will need to follow the steps below to make the Web proxy service or WWW service to wait for the SQL service to start:

  1. Start Registry Editor (Regedt32.exe), and locate the following Registry subkey in the HKEY_LOCAL_MACHINE subtree:

    \SYSTEM

        \CurrentControlSet
         \Services
          \W3SVC
    

  2. Double-click the DependOnService.

  3. Add MSSQLSVR (all caps) to the list of services.

  4. Click OK and quit the Registry Editor.

  5. Shut down and restart Windows NT.
Version           : WINNT:1.0,2.0
Platform          : winnt
Hardware          : ALPHA x86
Issue type        : kbprb
Solution Type     : kbworkaround


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.