After upgrading from version 3.2.2 to 3.5 you will get the following error when opening configuration manager:
The issue seems to happen when there is no record in Windows Credentials (Control Panel -> User Accounts -> Credential Manager) for EnterpriseReporter_IvKey which is typically created in new installations.
Enterprise Reporter stores account passwords to enable user impersonation when gathering specific data. To ensure the security of these credentials within the SQL database, the passwords are encrypted. However, encryption standards evolve over time, requiring periodic updates to the encryption algorithms used.
Starting with Enterprise Reporter version 3.5.0, we use the AES-256 algorithm (Advanced Encryption Standard with a 256-bit key) for password encryption. In contrast, earlier versions such as 3.2.2 and older used 3DES-192 (Triple Data Encryption Standard with a 192-bit key).
In all cases, encryption keys are uniquely generated using the Encryption Key Manager. These keys are stored securely in the Windows Credential Manager on the machine hosting the Enterprise Reporter Server. You can locate this by opening the Windows Credential Manager, navigating to the Windows Credentials tab, and locating the generic credential labeled "EnterpriseReporter_IvKey".
Please note that due to the change in encryption algorithms, upgrading from older versions may cause issues if the account passwords stored in the SQL database were encrypted using a now obsolete algorithm. This can lead to compatibility problems when upgrading to the latest supported versions.
Reset passwords (for all credentials) by doing the following:
1. Close Configuration Manager.
2. Stop ER server service.
3. Login to the SQL Server that hosts ER db using SQL Server Management Studio (SSMS) and run the following SQL command against ER database to reset passwords:
update tblCredentials set EncryptedPassword = null;
4. Start ER server service.
5. Start Configuration Manager.
6. Go to Configuration | Credential Manager and update account passwords. This will store and encrypt passwords using the new encryption algorithm.
