Views:
  1. Open SQL Server Management Studio.
  2. Right-click on the MobileArmorDB database name and go to Tasks then Back Up.

    Make sure the following options are correct:

    • Backup type: Full
    • Backup component: Database
  3. Click OK to save the backup database.

    Back Up Database

    Click the image to enlarge.

  4. Repeat steps A to C for MobileArmorLog database.
  5. Locate the backup file. It is usually located under the following location:

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup

  6. Open services.msc, then Stop SQL Server (SQLEXPRESS) service.
  7. Transfer the backup file on the new SQL Server.
 
Place the MobileArmorDB and MobileArmorLog on the backup folder of the new SQL Server to easily locate the backup file.
 

MSSQL BackUp

Click the image to enlarge.

  1. On the new SQL Server, open up Microsoft SQL Management Studio.
  2. Right-click on Databases and select Restore Database.
  3. Under the Restore Database Window, make sure you are on the General tab.
  4. In the General tab, go to Source and select Device.
  5. Click on the Browse icon that is on the right side to browse. Select the backup file and then click on ADD.

    Browse File

    Click the image to enlarge.

  6. Restore both MobileArmorDB and MobileArmorLog.
  7. Right-click on the restored database (MobileArmorDB) and select New Query.
  8. On the query window, type sp_change_users_login ‘report’ and click the !Execute button.

    Take note of the username. In this example, the username is “SQLEXPRESS”.

    SQL Express

    Click the image to enlarge.

  9. Right-click on the restored database (MobileArmorLog) and select New Query.
  10. On the query window, type sp_change_users_login ‘report’ and click the !Execute button.

    Take note of the username. For this example, the username is “SQLEXPRESS”.

    SQL Express 2

    Click the image to enlarge.

  11. Right-click on the restored MobileArmorDB database and select New Query.
  12. On the query window, type sp_change_users_login ‘auto_fix’,’Username’,NULL, ’Create_Password’ and click the !Execute button. The Username from the result of the sp_change_users_login ‘report’ query should be used as the Username.

    Create your password.

    • Should not contain all or part of the user's account name
    • Should be at least six characters in length
    • Should contain characters from three of the following four categories:

      • English uppercase characters (A through Z)
      • English lowercase characters (a through z)
      • Base 10 digits (0 through 9)
      • Non-alphanumeric characters (e.g., !, $, #, %)

      Messages

      Click the image to enlarge.

  13. Redo Step 11 for MobileArmorLog (Right-click on the restored MobileArmorDB database and select New Query.)
  14. Under Security > Logins, you should be able to see the user that you have used.

    SQL EXpress 3

    Click the image to enlarge.

  15. Right-click on the user and type in the new password you have created on Password field then confirm it by re-typing the password in the Confirm password field. Click OK.

    SQL Password

    Click the image to enlarge.

  16. Under the Login Window, go to User Mapping make sure MobileArmorDB and MobileArmorLog are selected.

    User Mapping

    Click the image to enlarge.

  17. Go back to the Policy where the SQL Express is installed.
  18. Use PolicyServerChangeSettings tool (Run as Administrator) to configure new connection with the new SQL server

    Policy Server Change Settings

    Click the image to enlarge.

  19. If the connection is successful, click on Write to Disk.
  20. Restart the PolicyServer Windows Service and Trend Micro Endpoint Encryption Service.

    You should be able to log in on the Policy Server.