The Event ID: 3220 stating 'Could not detect the MSMQ service' and Event ID: 2256 'The Archiving Task

v-437-3220

v-437-2256
This issue can occur when the ArchivingRetrievalTask and RetrievalTask tables in the EnterpriseVaultDirectory Database have the incorrect server name values present in the "MessageQueue" column.

Note: Before making any changes in SQL, ensure a database backup is obtained and Enterprise Vault is placed in backup mode.
Log into the SQL Management Studio and select the correct instance of SQL that contains the Enterprise Vault Directory Database.
Expand Databases - EnterpriseVaultDirectory - Tables ArchivingRetrievalTask.
Right click and select Edit top 200 rows.
Ensure that the Message Queue field contains the correct server hosts name.
Note: Perform the same steps for the Enterprise Vault Directory - RetrievalTask table.