How to copy the current configuration of Cayosoft Administrator from Production to Test server

Summary: This article contains step-by-step instructions on how to copy the current configuration of Cayosoft Administrator from Production to Test server.

Applies to: Cayosoft Administrator 7.0.0 or later

ID: KB20200417-1

1. On the Test server install the same version of Cayosoft Administrator as on Production server

2. Stop the Cayo Admin service

3.  On the Production server:

   1. Open the Cayosoft Administrator Configuration console

   2. Navigate to Home > Configuration > Settings > Configuration Databases

   3. Export the encryption key (Make note of the password)

   4. Stop the CayoAdminService service

   5. In File Explorer navigate to C:\Program Files\Cayo Software\AdminAssistant

   6. Copy all files listed as Database in C:\Program Files\Cayo Software\AdminAssistant\ on the Production server to C:\Program Files\Cayo Software\AdminAssistant\ on the Test server

      (Replace the files on the Test Server with the files from the Production server)

4.  On the Test server:
   
   1. Run the script below to disable all extensions. You will specify different connection accounts and enable them later:

#Script to disable Office 365 extension
Add-Type -Path "C:\Program Files\Cayo Software\AdminAssistant\System.Data.SQLite.dll"
$con = New-Object -TypeName System.Data.SQLite.SQLiteConnection
$con.ConnectionString = "Data Source=C:\Program Files\Cayo Software\AdminAssistant\Cayo.PolicyManager.db"
$con.Open()
$sql = $con.CreateCommand()
$sql.CommandText = "UPDATE 'extStatusesDb' SET 'enabled'=0 WHERE extId in ('Office365Ext', 'PM.Ext.AD', 'PM.Ext.ADLDS', 'PM.Ext.ExchangeOnPrem', 'PM.Ext.LyncOnPerm')"
$sql.ExecuteNonQuery()
##

2. Start the CayoAdminService

3. Open the Cayosoft Administrator Configuration Console

4. Navigate to Home > Configuration > Settings > Configuration Databases

5. Import the encryption key (Use the password you made note of the in step 2.3)

6. Navigate to Home > Configuration > Connected Systems Extensions

7. Check Extension is enabled for each extension that you need to use

8. For each extension specify connection account that is different from the account used for the same extension on the Production server

   Important: During installation, each Standalone Server must be configured to connect to the platforms to be managed by service accounts specific to that server.  For example, if you have two different servers each of which will be used to manage Office 365, two separate service accounts must be used. In other words, each Cayosoft Server should have its own set of service accounts for all managed platforms: Active Directory, Microsoft Office 365, Exchange Server on-premise, and Microsoft Skype Server on-premise. 

9. Don't forget to grant consent for Office 365 connection account 

10. Save changes

11. Navigate to Home > Configuration > Web Portal > Web Portal Settings

12. In Server URL specify the new server URL

13. If Self-Service Password Reset solution was enabled, provide an encryption password used to protect data stored in Active Directory. For that:

    1. Navigate to Home > Configuration > Web Portal > Web Actions > Common

    2. Select the Self-Service - Password Self-Service Enrollment Details rule

    3. Enter the encryption password, configured on the initial Service, to the Password to encrypt data in AD setting

14. Close the console and restart the CayoAdminService.