Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: How to upgrade the SQL Server Software

App Control: How to upgrade the SQL Server Software


  • App Control Server: All Supported Versions
  • Microsoft Windows Server: All Supported Versions
  • Microsoft SQL Server: All Supported Versions


How to upgrade the Microsoft SQL Server software?


  1. If an Agent is installed on the SQL Server, first move it into Local Approval.
  2. Stop the App Control Server & Reporter services and temporarily set them to Startup type: Disabled.
  3. Make a full backup of the DAS database.
  4. If the server is a VM, taking a snapshot to revert back to could be useful.
  5. Upgrade the SQL Server Instance.
  6. Once upgrade is complete, verify the DAS database is still there.
    • If database is not there, restore the DAS database from the backup you took before the upgrade.
  7. Once the DAS database is there and available, start the App Control Server & Reporter services.
  8. Set the services back to their original Startup type settings. By default these are:
    • App Control Server: Automatic.
    • App Control Reporter: Automatic
  9. Login to the Console and verify functionality.
  10. Move the Agent back to its original Enforcement Level.

Additional Notes

  • Check the Operating Environment Requirements documentation to verify which SQL Server versions are supported.
  • While adjusting the Agent Enforcement Level is not required, it may be helpful as your Console will be unavailable for Approvals/adjustments while the upgrade is occurring.
  • If you are finding errors after the upgrade, please open a support ticket for assistance.

Related Content

Labels (1)
Tags (2)
Was this article helpful? Yes No
100% helpful (1/1)
Article Information
Creation Date: