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]

Comentarios

Publicar un comentario

Dime si la información de este blog te sirvio.

Entradas populares de este blog

Comando FOR para archivos BAT

How To Configure iSCSI Initiator on Ubuntu 22.04|20.04

Guía de herramientas básicas para estudiantes: 31 apps y webs imprescindibles para ayudarte con los estudios