This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SUPPORT Q&A - How can I restore the root user ?

Offline Archive User over 15 years ago

mlsprivate - Tuesday, April 14, 2009 5:34 PM:

I have disabled root user, is there anyway to restore it? The admin looks don't have enough permision to do this.

Also, where to change the Vadmin password?

Any help are appreciated, thank you! David.

SamsAn - Wednesday, April 15, 2009 4:59 AM:

A way to enable a user is to execute sql like "UPDATE [User] SET logon_enabled='1' WHERE login_name='root'". You can apply it through SQL Query Analyzer or through nash.aspx utility under admin (just run "your_innovator_url/client/scripts/nash.aspx", select soapAction=ApplySQL and AML to send like <sql>UPDATE [User] SET logon_enabled='1' WHERE login_name='root'</sql>).

Ways to change vadmin password:

1. Login as vadmin and run Main MenuToolsChange Password command.

2. Execute sql like "UPDATE [User] SET password='c4ca4238a0b923820dcc509a6f75849b' WHERE login_name='vadmin'". Note: c4ca4238a0b923820dcc509a6f75849b is MD5 code of '1' and you can login under vadmin using 1 as the password then.