Resetting the password of the default admin user profile by running a batch file - Security Center 5.8 - 5.13

If you do not have the password for the default Admin user profile in Security Center, you must reset the old password, and then set a new one. The simplest method is to run a batch file on the Security Center server that SQL is running on.

1. In Windows, create a temporary file to store your batch file.
   For example,C:\Genetec Admin Pass.
2. Open a new file in Notepad and paste in the following text:
   Code

   UPDATE [user] set Password = 'd41d8cd98f00b204e9800998ecf8427e' where name = 'Admin'

   
3. Save the file as SC_deleteadminpass.sql in the temporary folder that you created.
4. Open Windows Command Prompt.
5. In the command window, open the temporary folder you created.
6. Run the following command:
   Code

   sqlcmd -S .\{SQL Instance} -d {Database name} -i SC_deleteadminpass.sql -o output.txt

   

   NOTE: The SQL Instance and Database name used by the Directory were noted when preparing to reset the password of the default Admin user profile. The SQL Instance is found in the Database server field.

   For example, if the Directory database uses SQL Express and the database name is "Directory", the command should be written as follows:

   Code

   sqlcmd -S .\SQLEXPRESS -d Directory -i SC_deleteadminpass.sql -o output.txt

   
7. In the temporary folder you created, open the file output.txt.
   If the script was successful, the following text appears in the file: (1 rows affected).