GMS: Reset the admin password for the Application Interface (GMSVP on Windows)

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

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, open a command prompt, navigate to [Install Drive]:\GMSVP\MySQL\bin and execute this command:

     mysql –h IPaddress --user=root --password=password 

     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

     update users

     set password = '5f4dcc3b5aa765d61d8327deb882cf99' where id = 'admin';

The Admin password is now ‘password’.