This solution contains instructions that will remove your existing MSDE/SQL webproxylog database from your system.  This means that all data currently within that database will be lost.  If this data needs to be kept, it should be backed up before continuing. 

These steps only need to be performed if the following is true:

• Your Chaperon is set to log to MSDE/SQL Server and not Access.
• Your Webproxylog has become full or damaged and is causing database errors to appear in Chaperon's Service Log.

Solution:

• Stop the Chaperon service by clicking the stop button within the Chaperon MMC or by typing "Net Stop Chaperon2000" within a command prompt.
• Close all applications that could be accessing the webproxylog database locally or remotely.  These include:  All Chaperon Administration MMCs, The Advanced Reporting Tool, The Chaperon Analyst, or any SQL query programs such as SQL Enterprise Manager or OSQL that could be using the database.
• From the machine running MSDE or SQL, open a command prompt and connect to the instance by typing "OSQL -E".  If your webproxylog was installed in a different instance of sql, that will need to be specified using the following instead: "OSQL -E -S ServerName\InstanceName"
• If connected successfully, you should receive a "1>" prompt, if an error occurs, ensure the command was typed correctly and that you are on the machine running MSDE/SQL.
• At the "1>" prompt type the following:  "drop database webproxylog".  When enter is pressed a "2>" prompt will appear.
• At the "2>" prompt type the following: "Go" then press enter.
• After a few minutes a message will appear stating the removal of the webproxylog.mdf and webproxylog.ldf.  If an error message appears it is most likely due to an application still accessing the webproxylog database.  Ensure all programs that could be accessing the database are closed and try again.
• At the "1>" prompt type "exit" to close OSQL.
• Open the Chaperon administration MMC and navigate to the Logging section.
• Press the "Create Database" button.
• If the MSDE/SQL is a default instance on the same machine, simply press go to start the database creation.  If the MSDE/SQL is on a remote machine or installed on a separate instance, server name or server name\instance name must be specified first.  logon ID and Password may need to be entered depending on your MSDE/SQL settings.
• Once the database creation is finished, click the "Done" button.
• Start Chaperon by clicking the start button or by typing "Net Start Chaperon2000" at a command prompt.

Chaperon will now begin logging user data from where it last stopped.  If connection errors occur, Click the "Edit" button in the Chaperon MMC under "Logging" and ensure that your connection settings to the Webproxylog database are correct.