User Guides
      Back to home
      1. Knowledge Base
      2. TruFleet
      3. User Guides

      WCP Database Manager SQL Fix

      When attempting to backup or restore a database using WCP Database Manager, an error occurs stating the backup was terminated abnormally. This process fixes the issue.

      1. This error occurs when attempting to backup a Database using WCP Database Manager:
      2. Navigate to Windows Services by searching "services" in the Window search bar.
      3. Highlight SQL Server (TALLYSMAN) and right click to open the properties.
      4. From within the properties, select the Log On tab and it will display as shown below
      5. Select the "Local System Account" option and tick "Allow service to interact with desktop" and click apply.
      6. A message will be displayed stating the changes will not take effect until you restart the services.
      7. Restart the service SQL Server (TALLYSMAN)
      8. You should be able to properly backup the database using WCP Database Manager.