XenMobile: How to Reset CLI Administrator Password in Microsoft SQL

Xenmobile
Objective

This article describes how to reset local device manager administrator password in Microsoft SQL.

Complete the following steps to reset local device manager administrator password in Microsoft SQL:

  1. Open SQL Server Management Studio > Databases > DB_Service > Tables.
  2. Select and highlight the table named dbo.SECURITY_PRINCIPAL, right-click and choose Select top 1000 rows.
  3. Search for the first entry in /group/MSP, which should be the local admin name (in this example, it is called administrator) and note the PRINCIPAL_ID (=8), as displayed in the following screen shot.
    User-added image
  4. To edit the table dbo.SECURITY_CREDENTIAL, right-click and select Edit Top 200 Rows.
  5. Search for the PRINCIPAL_ID that you noted from the previous table (in this example, it is 8) and type the new password in plain text in the COLUMN_VALUE field, and set the value in the field IS_ENCODED from 1 to 0.
    User-added image
  6. Apply the changes and close the SQL Server Management Studio application, so the database is not locked.
  7. Restart the XenMobile 10 Server.
  8. Attempt to login to the web GUI with the user administrator and the new password.
  9. This login attempt will fail.
  10. Reopen the database and view the dbo.SECURITY_CREDENTIAL (Right click the table and choose Select Top 1000 Rows).
  11. The password should now be encoded.
    User-added image
  12. Copy the newly encoded password from COLUMN_VALUE field.
    User-added image
  13. Edit the dbo.useraccnts table (Right click and choose Edit top 200 rows).
  14. Paste the password copied in Step 12 in the pwd field for the user administrator.
    User-added image
  15. Save the changes to the dbo.useraccnts table.
  16. Restart the XenMobile server.
  17. After the XenMobile server has restarted, access the web GUI.
  18. Login with the administrator user and the new password.