Resetting the password of the default Admin user profile through SQL - 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. 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:
   Code

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