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]