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:
- Open SQL Server Management Studio > Databases > DB_Service > Tables.
- Select and highlight the table named dbo.SECURITY_PRINCIPAL, right-click and choose Select top 1000 rows.
- 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.
- To edit the table dbo.SECURITY_CREDENTIAL, right-click and select Edit Top 200 Rows.
- 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.
- Apply the changes and close the SQL Server Management Studio application, so the database is not locked.
- Restart the XenMobile 10 Server.
- Attempt to login to the web GUI with the user administrator and the new password.
- This login attempt will fail.
- Reopen the database and view the dbo.SECURITY_CREDENTIAL (Right click the table and choose Select Top 1000 Rows).
- The password should now be encoded.
- Copy the newly encoded password from COLUMN_VALUE field.
- Edit the dbo.useraccnts table (Right click and choose Edit top 200 rows).
- Paste the password copied in Step 12 in the pwd field for the user administrator.
- Save the changes to the dbo.useraccnts table.
- Restart the XenMobile server.
- After the XenMobile server has restarted, access the web GUI.
- Login with the administrator user and the new password.