Skip to content

I forgot my manager password and want to reset it to its initial setting

Answer

Please execute the UPDATE statement.

Overview

Normally, to "Reset password", the tenant manager clicks the "Reset password" button on the edit screen for the user in "User Management". However, if the manager forgets their own password and cannot change it from the screen, the password can be changed by executing the following SQL against the database.

Limitations

  1. This procedure is valid when Pleasanter manages login users and passwords by itself. If you have set up LDAP or SAML authentication, please contact the manager of the LDAP or SAML to which you are connecting.
  2. This procedure is for those who have built Pleasanter themselves. If you are using Pleasanter.net and would like to change your password, please refer to the following link.
    FAQ: I forgot my password and would like to reset it (Pleasanter.net)

Operation Procedure

  1. Log in to the server on which Pleasanter is installed.
  2. Start SSMS (SQL Server Management Studio).
  3. From the "Object Explorer", expand "Databases" and select "Implem.Pleasanter".
  4. Right-click "Implem.Pleasanter" and click "New Query".
  5. Execute the SQL in the sample code below.
  6. Log in to Pleasanter with the changed password.
  7. After logging in, set up the user again.

Code Samples

  • This SQL is for SQL Server only.
  • Replace "User ID for which password is to be changed" with the actual user ID.
  • Replace "New password" with the password you want to change (alphanumeric characters, numerical value, symbols).
use [Implem.Pleasanter]
declare @password nvarchar(128) = 'Password after change'
update [Users] set
[Password] = (select lower(convert(nvarchar(128), hashbytes('SHA2_512', cast(@password as varchar(128))), 2)))
where LoginId = 'User ID for which password is to be changed';