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

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

Environment

  • App Control(Formerly CB Protection) Server: All Versions
  • Microsoft Windows Server: All Supported Versions

Objective

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

Resolution

  1. Backup the DAS database:
  2. Backup the console certificate:
  3. Backup the IIS certificate
  4. Uninstall App Control Server application:
    1. Login to the App Control Server
    2. If a App Control Agent is installed on the server, set it to a disabled mode
    3. Navigate to Start > Run > type “appwiz.cpl > click OK.
    4. Programs and Features will open
    5. Find and select "App Control Server" (Bit9 Server in 7.x)
    6. Click "Remove" or "Uninstall"
    7. Wait for uninstall to complete
  5. Open SQL 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, navigate to Properties > Files
  7. Make note of the "File name" and "Path" locations > click OK
  8. Right-click on DAS > Tasks > click Detach
  9. Check the box for "Drop Connections" > click OK
  10. Stop the SQL Server (Instance) service
  11. In Windows explorer, browse to the path location noted in step 9.
  12. Move DAS files (das.mdf, das_abinst.ndf, das_abtemp.ndf, das_events.ndf, and das_log.ldf) to new server.
  13. Install SQL on new server:
  14. Login to SQL Management Studio, right click Databases > Click Attach
  15. Browse to and select das.mdf file that was moved in step 8
  16. Reinstall App Control Server:
  17. Confirm console access
  18. Confirm Agents are connecting

Related Content


Labels (1)
Tags (2)
Was this article helpful? Yes No
100% helpful (1/1)
Article Information
Author:
Creation Date:
‎11-03-2014
Views:
5827
Contributors