Just Published! 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

Environment

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

Objective

How to upgrade the Microsoft SQL Server software?

Resolution

  1. Adjust the Enforcement Level of the App Control Agent on the SQL Server (if installed) to an Enforcement Level other than "High".
  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
Author:
Creation Date:
‎03-07-2019
Views:
919
Contributors