- App Control Server: All Supported Versions
- Microsoft SQL Server: All Supported Versions
- Microsoft Windows Server: All Supported Versions
To move the DAS database to a new SQL server/instance name
- Make a full backup of the current database.
- Export a copy of the current Agent Communication Certificate.
- Export a copy of the current IIS Certificate.
- Uninstall App Control Server application:
- Login to the App Control Server as the Carbon Black Service Account.
- If an App Control Agent is installed on the server, temporarily move it into a Disabled Policy.
- Navigate to Start > Run > appwiz.cpl > click OK.
- Using the Programs and Features wizard, uninstall App Control Server.
- 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.
- Expand Databases > right-click DAS > Properties > Files > note the File Name and Path locations. Click OK.
- Right-click DAS > Tasks > click Detach > check the box for Drop Connections > click OK.
- Stop the SQL Server (Instance) service
- In Windows explorer, browse to the Path Location to locate the Files previously noted in Step 6.
- Move the DAS files (das.mdf, das_abinst.ndf, das_abtemp.ndf, das_events.ndf, and das_log.ldf) to the new server.
- Install SQL Server as outlined in Server Documentation > SQL Server Configuration Guide on VMware Docs.
- Using SQL Management Studio, right click Databases > Attach > specify the new location of das.mdf (Step 10).
- 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.
- After installation is complete, login to the Console and confirm Agents are connecting.