To change the password
- In IIS Manager, stop the Defender Web Interface site.
- On the Defender Management Portal computer, run DBEncrypt.exe located in the folder %ProgramFiles%\One Identity\Defender\Management Portal\Tools, and complete the dialog box that appears:
- In the Old Password box, type the password with which the database was encrypted.
- In the New Password and Confirm New Password boxes, type the new password with which you want to encrypt the database.
- Click Apply, and then close the dialog box.
- Use the aspnet_regiis.exe tool to decrypt the database connection string in the Web.config file, so that you can specify the new password in that file. You can find aspnet_regiis.exe in one of these folders:
- On an x86 system - %WinDir%\Microsoft.NET\Framework\v4.0.30319
- On an x64 system - %WinDir%\Microsoft.NET\Framework64\v4.0.30319
Sample command to decrypt the database connection string in the Web.config file on an x86 system:
%WinDir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -pdf "connectionStrings" "%ProgramFiles%\One Identity\Defender\Management Portal\WWW"
- In the Web.config file, update the database connection string with the new password:
- In a text editor, open the Web.config file located in the folder %ProgramFiles%\One Identity\Defender\Management Portal\WWW
- In the Web.config file, locate the <connectionStrings> element, and modify the SelfReg.sdf connection string within that element to include the new password. Example:
connectionString="data source=|DataDirectory|\SelfReg.sdf;Max Database Size=4091;password=NewDatabasePassword"
where NewDatabasePassword
is the password you have set in Step 2 of this procedure.
- Save and close the Web.config file.
- Use the aspnet_regiis.exe tool to encrypt the database connection string in the Web.config file, so that the password is not displayed as plain text. You can find aspnet_regiis.exe in one of these folders:
- On an x86 system - %WinDir%\Microsoft.NET\Framework\v4.0.30319
- On an x64 system - %WinDir%\Microsoft.NET\Framework64\v4.0.30319
Sample command to encrypt the database connection string on an x86 system:
%WinDir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -pef "connectionStrings" "%ProgramFiles%\One Identity\Defender\Management Portal\WWW" -prov "DataProtectionConfigurationProvider"
- In IIS Manager, start the Defender Web Interface site.
By default, the Defender Management Portal uses SQL Server Compact database. However, from Defender release 6.3.1 and above SQL Server Express database can be used as the Management Portal database. This tool can be used to switch the Defender database from SQL Compact to SQL Express.
To migrate the database
- On the Defender Management Portal computer, run DBSwap.exe located in the folder %ProgramFiles%\One Identity\Defender\Management Portal\Tools.
- Select the checkbox for “Switch to SQL Express”.
- Click on Submit button, database is switched to SQL Express successfully.
-
On the warning message displayed:
- If you are switching to SQL Express database for the first time:
-clicking on Yes will switch database to SQL Express successfully.
-clicking on No, you will have to switch back to Compact database.
- If you are already using the SQL Express database for Management portal, clicking Yes will overwrite the data on Express databases with data from the SQL Compact databases.
- Similarly, select checkbox for “Migrate logs from Compact Databases to Express Databases” and click on Submit button, logs will be migrated successfully.
Note: The data in the destination database will be overwritten after the migration. Hence it is recommended to use this option only while switching to SQL Express for the first time to avoid any data loss.
Each Defender Security Server generates logs, which are retrieved by the Log Receiver Service running on the Defender Management Portal computer. The retrieved logs are then used to do the following:
- Display authentication statistics on the Dashboard tab of the Defender Management Portal.
- Provide troubleshooting information on the Helpdesk tab of the Defender Management Portal.
- Display information on the Actions tab of the Defender Management Portal.
Defender Security Servers deployed in your environment automatically detect the Log Receiver Service and provide their logs to the service.
In situations where the connection between the Defender Security Server and the Log Receiver Service is interrupted, the logs to be sent to the service are cached in a .dat file on the Defender Security Server. After the connection is restored, the log data cached in the .dat file is sent to the Log Receiver Service.
If the Log Receiver Service is running and the connection between this service and the Defender Security Server is working properly, the .dat file should not grow in size.
On a Defender Security Server, you can find the .dat file in the following folder:
%ProgramFiles%\One Identity\Defender\Security Server\Logs
The name of the .dat file has the following format:
<ServerName>.LogQueue.dat
Where <ServerName> is the name of the computer on which the Defender Management Portal is installed.