Error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value..." (4262170)

Mailboxes are not being archived. When checking the corresponding wlog files of the mailboxes in question the following error message is at the end of the wlog file:

Error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

This is due to an invalid ConnectionString in Archive Manager Configuration editor. In AM 4.7 the ConnectionString initially appears in the format:

server=SQL_SERVER_NAME;Trusted_Connection=yes;database=AM_DATABASE_NAME

If however one clicks on 'Change' button and then either clicks OK or chooses to select the Database by entering manually the values, the ConnectionString will change to something like:

Data Source=SQL_SERVER_NAME;Initial Catalog=AM_DATABASE_NAME;Integrated Security=True

There is no way of reverting back to the previous format and the error mentioned above is displayed in all wlog files indicating that AM can no longer process the mailboxes.

Use the attached utility to encrypt the ConnectionString and then edit the registry key accordingly.

1. Run the utility

2. In the Decrypted field type the Connection String in the format:

server=SQL_SERVER_NAME;Trusted_Connection=yes;database=AM_DATABASE_NAME

3. Copy the value that appears in the Encrypted field

4. Stop all AM services

5. Edit the Registry:

HKEY_LOCAL_MACHINE\SOFTWARE\AfterMail\ConnectionString

or

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\AfterMail\ConnectionString

6. Paste the value copied in step 2 above

7. Restart the AM services.

8. Check one of the wlog files and check that they no longer display the Multiple-step OLE DB error