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
- If an Agent is installed on the SQL Server, first move it into Local Approval.
- Stop the App Control Server & Reporter services and temporarily set them to Startup type: Disabled.
- Make a full backup of the DAS database.
- If the server is a VM, taking a snapshot to revert back to could be useful.
- Upgrade the SQL Server Instance.
- 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.
- Start the App Control Server & App Control Reporter services and set the Startup type of each to: Automatic.
- 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