|Applies To||RSA Product Set: Archer|
RSA Version/Condition: 5.5.4
O/S Version: Server 2012 R2
|Issue||When changing servers and connecting them to the original database User Names get changed to something that looks like "E2TYczRpGrWaq/GSt6VWsm84LU3Ki90DImDn5Y2w+KY="|
This issue is by design as the encryption key is stored in the configuration database. If this encryption key is different between the time the user name and password are encrypted and decrypted then the values will not be decrypted properly. There are a number of ways this encryption key will be different. Changing from one environment to another, restoring configuration database, creating a new configuration database, wiping out the key in the configuration database, restoring the instance database back to a time when the encryption key was different.
Make sure the encryption key saved in the config DB matches the on the target environment so the username gets decrypted correctly. Within the Archer Instance Database it contains certain elements which are encrypted (e.g., passwords for LDAP and Data Feeds). The key for these is stored in the config database. If you take a database from one environment and move it to another, you need to make sure that you have the same encryption key or the encryption values will not be decypherable.
SELECT * FROM dbo.tblProperty WHERE property_key = 'TextEncrypter'
UPDATE tblProperty SET property_value = 'xxxxxx' WHERE property_key = 'TextEncrypter'