Migrate the Database to a New SQL Server

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Steps to move the existing App Control (DAS) database to a new SQL Server/instance name.

Environment

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

Resolution

1. Before proceeding:
   • Create a full backup of the DAS database.
   • Backup the Communication Certificate.
2. Uninstall the App Control Server:
   1. If an App Control Agent is currently installed on the server, temporarily disable Tamper Protection and move it to Local Approval.
   2. Log in to the application server as the Carbon Black Service Account.
   3. Navigate to Start > Run > appwiz.cpl > click OK.
   4. Make a note of the App Control Server version currently installed, and uninstall.
3. Log in to the existing SQL Server:
   1. Launch SQL Server Management Studio
   2. Expand Databases > right click das > Tasks Detach...
   3. Check the box to Drop Connections.
   4. Click OK
4. Log in to the new SQL Server:
   1. Restore the App Control das database.
   2. Verify the relevant SQL Permissions are applied to the Service Account.
5. Install App Control server as outlined in Server Installation guide on VMware Docs
   • It is best practice to use the same App Control Server version as was used previously, and then upgrade to the latest version.
   • It is not recommended to change the Server Address during install.
   • During install choose "Use Existing Database".
   • During install choose the Certificates stored in the database or create a new one and then restore it from the backup.
6. After installation is complete, log in to the Console and confirm Agents are connecting.

Additional Information

The only way to point the Console to a new SQL Server is during installation.