Resetting the password of the default Admin user profile - Security Center 5.7 - 5.12

Before resetting the password of the default Admin user profile in Security Center, you must complete some prerequisite steps.

1. Ensure that the default Admin user profile is active.
   If the default Admin user profile has been deactivated, you must reactivate it to log on to Security Center as the Admin user.
2. Secure the SQL server.
   For more information, watch this video to learn about security best practices.
3. Ensure that you have either sysadmin privileges or the role of db_owner for the Directory database.
4. Back up the Directory.
   • If your system is configured with Directory failover, see Backing up the Directory database with failover.
   • If your system is not configured with Directory failover, see Backing up the Directory database.
5. Obtain the SQL instance and database name:
   1. Open Server Admin.
   2. Select the Directory server.
   3. From the Directory section, note the name of the SQL instance in the Database server field of .
      The SQL instance is found alongside the machine name.

      

   4. Note the name of the database in the Database name field of the Directory section.

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:

   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:

   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:

   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).

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. Instead of running a batch file, this can be done using SQL Server Management Studio.

1. Verify that SQL Server Management Studio is installed.
   If it is not installed, download it from one of the following links:
   • Microsoft SQL Server 2022 Express
   • Microsoft SQL Server 2019 Express
   • Microsoft SQL Server 2017 Express
   • Microsoft SQL Server 2016 Express
   • Microsoft SQL Server 2014 Express
2. In Windows, click Start > Microsoft SQL Server Tools > SQL Management Studio.
3. From the Server name list on the login page, select the name of the database server that hosts the Directory.
   You can find it in the Database server field in Server Admin > Server > Directory. For more information, see preparing to reset the password of the default Admin user profile.
4. Click Connect.
5. In the Object Explorer window, expand the Databases folder and find the name of the database that belongs to the Directory.
   This was noted when preparing to reset the password of the default Admin user profile.
6. Right-click the Directory database and select New Query.
   A new tab with a blank window appears.
7. Create a script by pasting the following text into the window:

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

8. Click Execute.
   If the script ran successfully, the following text appears in the Messages window: (1 row(s) affected).

After you reset the password of the default Admin user profile, you must set a new password.

1. From the Config Tool homepage, open the User management task.
2. From the Administrators user group, select Admin user .
3. Click the Properties tab.
4. In the Password settings section, click Change password.
5. In the Change password dialog box, enter and confirm a new password.
6. Click OK.