HOWTO: Reset Admin Password in Sonicwall ViewPoint

The ViewPoint user login credentials are stored in the USERS table, but the password is stored as a one-way hash. To reset the Application Interface Admin account password to 'password', follow the steps below.

Resolution or Workaround :

1. Connect to the database.

a. For SQL Server 2000, use Query Analyzer.

b. For SQL Server 2005, use SQL Server Management Studio.

c. For MySQL, execute this command at a command prompt:

[GMSVP]\MySQL\bin> mysql —user=root —password=password –h IPaddress

where password is the database password chosen during phase 2 of the installation, and IPaddress is the IP address of the GMS server

d. For MSDE, execute this command at a command prompt:

C:> osql –U sa –P password –S IPaddress/SNWL

where password is the database password chosen during phase 2 of the installation, and IPaddress is the IP address of the GMS server

2. Execute this SQL:

use sgmsdb; <press enter>

update users set password = '5f4dcc3b5aa765d61d8327deb882cf99' where id = 'admin'; <press enter>

The Admin password is now ‘password’.