Timeout errors when using SQL database logging

Problem

You are using Folder Permissions Manager with SQL database logging and experience intermittent timeout errors.

Reason

From time to time Folder Permissions Manager deletes old records from the SQL database. If the database is very large, deleting old records may take longer than the default timeout of 30 seconds.

Solution

Follow these steps to resolve the problem:

1. Use Folder Permissions Manager version 9.0.1 or later.
2. Open the Windows Registry Editor.
3. Browse to the following registry key (create it if it does not exist):

   HKEY_LOCAL_MACHINE\SOFTWARE\Symprex\Folder Permissions Manager\Database Logging
   

4. Create a new DWORD value with name:

   Command Timeout
   

5. Set the new value to the desired timeout value in seconds (the default is 30).

If you change the value, you need to restart Folder Permissions Manager for the new value to take effect.