Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Migrating SQL Express to Full blown SQL server in Endpoint Encryption

    • Updated:
    • Product/Version:
    • Endpoint Encryption 6.0
    • Platform:
    • Windows Server 2008 32-Bit
    • Windows Server 2008 64-Bit
    • Windows Server 2012
    • Windows Server 2016
Summary

Learn how to move or migrating SQL Express database used by the Policy Server to a Full blown SQL server.

Details
Public
  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.

    Backup DB

  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.
 

Backup

  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.

    Restore DB

  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”.

    username

  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”.

    username

  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., !, $, #, %)

      create password

  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.

    Logins

  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.

    confirm password

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

    User Mapping

  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

    PolicyServerChangeSettings

  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.

Premium
Internal
Partner
Rating:
Category:
Configure
Solution Id:
000247161
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.