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: All Supported Versions
  • Microsoft Windows Server: All Supported Versions
  • Microsoft SQL Server: All Supported Versions

Objective

How to upgrade the Microsoft SQL Server software?

Resolution

  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 attached and online.
    • If database is not, restore the DAS database from the backup you took before the upgrade.
  7. Start the App Control Server & App Control Reporter services and set the Startup type of each to: Automatic.
  8. Log in to the Console and verify functionality.

Additional Notes

  • Check the Operating Environment Requirements documentation to verify which SQL Server versions are supported.
  • The latest updates for Microsoft SQL Server can be found here.
  • App Control Server does require the latest Cumulative Update (includes functional and security fixes), rather than the GDR (security fixes only).
  • 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:
12347
Contributors