Resetting the Directory Admin password in Omnicast™ - Omnicast™ 4.0 - 4.8

series
Omnicast™ 4.0 - 4.8
revised_modified
2019-03-18

Resetting the Directory Admin password in Omnicast™ by running a batch file

If you forgot the Admin password for the Directory in Omnicast™, you can clear the old password by running a batch file on the server that SQL is running on, and then set a new password.

Before you begin

  • Make sure that you have sysadmin privileges to the Directory database. If you cannot get sysadmin privileges, make sure that you at least have the role of db_owner.
  • Back up the Directory database. If you have Omnicast™ version 4.8, back up the Directory database using the Omnicast™ Backup Tool. If you have an earlier version of Omnicast™, back up the Directory database using SQL Management Studio.

What you should know

The Admin password for Omnicast™ is stored in the Directory database. To reset the password, you must modify a row in one of the database tables. If you are uncomfortable with running a batch file, you can also reset the Admin password in the following ways:
  • Contact the Genetec™ Technical Assistance Center (GTAC) and send us a backup of the Directory database. Upon receiving the backup, technical support will reset the password and send the database back to you.
  • Use SQL Server Management Studio Express.
NOTE: This information used to be found in the deprecated knowledge base article KBA-00176.

Procedure

  1. Obtain the SQL instance and database name as follows:
    1. Open Server Admin.
    2. Select the Directory service.
    3. Click the General tab.
    4. Note the values in the Data Server and Database fields.
  2. Open a new text file in Notepad, and paste in the following text:
    DELETE FROM EntityConfigDatac WHERE EntityGuid = 'd4a92506-ca87-41d1-afd1-54cdcf32985c' and Valuename = 'Password'
  3. Save the file as Omnicast_deleteadminpass.sql in a temporary folder (for example, c:\genetec).
  4. Stop the Directory service.
  5. Open Windows Command Prompt.
  6. In the command window, open the temporary folder you created (for example, cd c:\genetec).
  7. Run the following command:
    sqlcmd -S <SQL Instance> -d <Directory database name> -i Omnicast_deleteadminpass.sql -o output.txt

    You obtained the SQL Instance and Directory database name in Step 1.

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

    The password is cleared. You can log on to the Directory without a password.

  9. Restart the Directory service.
  10. To set a new password, open Config Tool and click System > Change password.

Results

Your new password to log on to the Directory is set.

Resetting the Directory Admin password in Omnicast™ through SQL

If you forgot the Admin password for the Directory in Omnicast™ and you do not want to reset the password by running a batch file, you can reset the password in SQL Server Management Studio Express.

Before you begin

  • Make sure that you have sysadmin privileges to the Directory database. If you cannot get sysadmin privileges, make sure that you at least have the role of db_owner.
  • Back up the Directory database. If you have Omnicast™ version 4.8, back up the Directory database using the Omnicast™ Backup Tool. If you have an earlier version of Omnicast™, back up the Directory database using SQL Management Studio.

What you should know

The Admin password for Omnicast™ is stored in the Directory database. To reset the password, you must modify a row in one of the database tables. If you are uncomfortable with creating and running scripts, you can also reset the Admin password by contacting the Genetec™ Technical Assistance Center (GTAC) and sending us a backup of the Directory database. Upon receiving the backup, technical support will reset the password and send the database back to you.
NOTE: This information used to be found in the deprecated knowledge base article KBA-00176.

Procedure

  1. Obtain the SQL instance and database name as follows:
    1. Open Server Admin.
    2. Select the Directory service.
    3. Click the General tab.
    4. Note the values in the Data Server and Database fields.
  2. Download and install SQL Server Management Studio Express. You can download the software at the following links:
    NOTE: SQL Server Express must be the same version or a later version than the SQL database that is installed on the server.
  3. Stop the Directory service.
  4. In Windows, click Start > All Programs > Microsoft SQL Server > SQL Management Studio.
  5. From the Server name drop-down list on the login page, select the name of the Data Server you noted in step 1.
  6. To log on to SQL Server Management Studio, click Connect.
  7. In the Object Explorer window, expand the Databases folder and find the name of the Directory database you noted in step 1.
  8. Right-click the Directory database and select New Query.
    A new tab with a blank window appears.
  9. Create a script by pasting the following text into the window:
    DELETE FROM EntityConfigDatac WHERE EntityGuid = 'd4a92506-ca87-41d1-afd1-54cdcf32985c' and Valuename = 'Password'
  10. Click Execute.
    If the script ran successfully the following text appears in the Messages window: (1 row(s) affected). The password has been cleared. You can log on to the Directory without a password.

  11. Restart the Directory service.
  12. To set a new password, open Config Tool and click System > Change password.

Results

Your new password to log on to the Directory is set.