After upgrading the DirectAudit collector, the collector is no longer able to connect to the AuditStore database
Problem: After upgrading the DirectAudit collector, the collector is no longer able to connect to the AuditStore database. The error is seen:
"The Collector is not able to use the database Data Source=cnt-audit-stor.xxx-dom.com;Initial Catalog=auditstore-2016-12-08:NonBreakingAndOlder"
Cause: The error is realized when the collector version is not compatible with the AuditStore version. The AuditStore needs to be at the same or a newer version than the collector.
Solution: The AuditStore database needs to be upgraded before upgrading the collector.
The AuditStore databases and the management database and be upgraded interactively using the Database Maintenance Wizard or by running the following command after open a DOS command line, go to the DirectAudit directory, and run command below: