- Open SQL Server Management Studio.
-
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
-
Click OK to save the backup database.
Click the image to enlarge.
- Repeat steps A to C for MobileArmorLog database.
-
Locate the backup file. It is usually located under the following location:
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup
- Open services.msc, then Stop SQL Server (SQLEXPRESS) service.
- Transfer the backup file on the new SQL Server.
Click the image to enlarge.
- On the new SQL Server, open up Microsoft SQL Management Studio.
- Right-click on Databases and select Restore Database.
- Under the Restore Database Window, make sure you are on the General tab.
- In the General tab, go to Source and select Device.
-
Click on the Browse icon that is on the right side to browse. Select the backup file and then click on ADD.
Click the image to enlarge.
- Restore both MobileArmorDB and MobileArmorLog.
- Right-click on the restored database (MobileArmorDB) and select New Query.
-
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”.
Click the image to enlarge.
- Right-click on the restored database (MobileArmorLog) and select New Query.
-
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”.
Click the image to enlarge.
- Right-click on the restored MobileArmorDB database and select New Query.
-
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., !, $, #, %)
Click the image to enlarge.
- Redo Step 11 for MobileArmorLog (Right-click on the restored MobileArmorDB database and select New Query.)
-
Under Security > Logins, you should be able to see the user that you have used.
Click the image to enlarge.
-
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.
Click the image to enlarge.
-
Under the Login Window, go to User Mapping make sure MobileArmorDB and MobileArmorLog are selected.
Click the image to enlarge.
- Go back to the Policy where the SQL Express is installed.
-
Use PolicyServerChangeSettings tool (Run as Administrator) to configure new connection with the new SQL server
Click the image to enlarge.
- If the connection is successful, click on Write to Disk.
-
Restart the PolicyServer Windows Service and Trend Micro Endpoint Encryption Service.
You should be able to log in on the Policy Server.