How To: Resetting the password for the 'admin' web user on IpSwitch WhatsUP

Version: All Versions; v11.x; v12.0.0; v12.3.0; v12.3.1; v12.4.0; v12.x; v14.0.0; v14.1.0; v14.1.1; v14.1.2; v14.2.0; v14.2.1; v14.3.0; v14.3.1; v14.4.0; v14.x

Description:  forgot the password for the WhatsUp Gold default 'admin' user in the web interface. How can I reset it? Yes.


Solution:
Execute the following SQL statement against the WhatsUp database in your SQL instance.  If WhatsUp Gold is using a SQL instance owned by your organization, have your database administrator execute this SQL statement:

     UPDATE [dbo].[WebUser] SET [sPassword] = DEFAULT WHERE [nWebUserID] = 1

If you are using the default WHATSUP SQL Express instance installed by WhatsUp Gold, you can execute the following case-sensitive command at a command-prompt on the WhatsUp Gold computer.

     sqlcmd -E -S "(local)\WHATSUP" -d "WhatsUp" -Q "UPDATE [dbo].[WebUser] SET [sPassword] = DEFAULT WHERE [nWebUserID] = 1"

You should now be able to login to the web interface as the admin user (in some installations, the default password is admin).

Note: It is strongly recommended that the password be manually changed for the admin user upon first login to the web interface after resetting the password.

Tip: To see a list of all available user names, execute the following command against the WhatsUp database in your SQL instance:

     SELECT [nWebUserID], [sUserName] FROM [dbo].[WebUser]