App Control: How to Migrate the DAS Database to a New Server

[#1]

Environment

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

Objective

To move the DAS database to a new SQL server/instance name

Resolution

1. Make a full backup of the current database.
2. Export a copy of the current Agent Communication Certificate.
3. Export a copy of the current IIS Certificate.
4. Uninstall App Control Server application:
   1. Login to the App Control Server as the Carbon Black Service Account.
   2. If an App Control Agent is installed on the server, temporarily move it into a Disabled Policy.
   3. Navigate to Start > Run > appwiz.cpl > click OK.
   4. Using the Programs and Features wizard, uninstall App Control Server.
5. Open SQL Server Management Studio.
   • Use an account with explicit db_owner and dbo schema permission on DAS.
   • Group membership is not sufficient for the login, as groups cannot have default schema assigned.
   • The login account needs these permission and schema directly assigned.
6. Expand Databases > right-click DAS > Properties > Files > note the File Name and Path locations. Click OK.
7. Right-click DAS > Tasks > click Detach > check the box for Drop Connections > click OK.
8. Stop the SQL Server (Instance) service
9. In Windows explorer, browse to the Path Location to locate the Files previously noted in Step 6.
10. Move the DAS files (das.mdf, das_abinst.ndf, das_abtemp.ndf, das_events.ndf, and das_log.ldf) to the new server.
11. Install SQL Server as outlined in Server Documentation > SQL Server Configuration Guide on VMware Docs. 
12. Using SQL Management Studio, right click Databases > Attach > specify the new location of das.mdf (Step 10).
13. Install App Control Server as outlined in Server Documentation > Server Installation Guide on VMware Docs.
    • When prompted, choose "Use Existing Database".
    • When prompted, use the Console and IIS Certificates that were backed up in Step 2 and Step 3.
14. After installation is complete, login to the Console and confirm Agents are connecting.

Related Content

App Control: How to Migrate the DAS Database to a New Partition