Important: This process only works for Envision 4.0.0, not version 4.1.0.
In Envision 4.0.0, the administrator password is stored in hashed format in the back-end SQL database.
To reset the password, do the following:
Log into the Envision appliance directly through Microsoft Terminal Services using the "master" account credentials.
Once logged in, start up the interactive SQL editor by double-clicking E:\nic\4000\<site name>\database\cmd\startISQL.cmd. (This should open the interactive SQL editor automatically with no request for credentials).
Once in the interactive SQL editor, in the SQL Statements window, type: select * from normal_user and then press F5 to execute. You should see a list of the users configured on the system. The first entry listed should be the administrator account.
Make note of the current hash in the column titled Data7.
To reset the password, we are going to drop the user from the table and then add the user back in with the correct password hash for the default administrator password ("administrator").
To drop the current administrator record, type: delete from normal_user WHERE name = 'administrator' and then press F5.
To add the administrator user record back, type: insert into normal_user values (0x00000000000000000000000000000001,1, 'administrator','','','',1,'',NULL,NULL,NULL,NULL,NULL,'P1oGeBq45LkyUP1mTQP19LW2eU',NULL,NULL,1,NULL) and then press F5.
To verify that the updated entry is there, type: select * from normal_user and then press F5.
Once confirmed, type: commit and then press F5.
You should now be able to log into the Web interface with the default administrator/administrator credentials.
Hello Kubilay:
Important: This process only works for Envision 4.0.0, not version 4.1.0.
In Envision 4.0.0, the administrator password is stored in hashed format in the back-end SQL database.
To reset the password, do the following:
You should now be able to log into the Web interface with the default administrator/administrator credentials.
Thank you.
- Michael