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 there.
- If database is not there, restore the DAS database from the backup you took before the upgrade.
- Once the DAS database is there and available, start the App Control Server & Reporter services.
- Set the services back to their original Startup type settings. By default these are:
- App Control Server: Automatic.
- App Control Reporter: Automatic
- Login to the Console and verify functionality.
- 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
