Upgrade the SQL Server Software

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Steps to upgrade the SQL Server currently hosting an App Control database.

Environment

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

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 Information

• 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.