Page History

...

1. Close the IDERA SQL Compliance Manager Management Console, if running.
2. Stop the SQL Compliance Collection Service.
3. Back up all of the SQLcompliance databases.
   1. SQLcompliance and SQLcompliance.Processing are the core databases.
   2. SQLcompliance_[instance name] contains the live audit data.
   3. SQLcmArchive_[instance name]_[date] contains the archive data.
4. Check the CollectionServerTraceFiles folder on the collection server for trace files.
   1. If there are any files, make a copy in another location.
   2. If there are lots of files older than 1 day, please contact support for help with these older trace files.
5. Run the setup.exe for IDERA SQL Compliance Manager using Run as Administrator. 
   
   1. The setup.exe is a two-part installer.
      1. The IDERA Dashboard is installed first.
      2. The SQL Compliance Manager upgrade will be started after the Dashboard installation has completed.
   2. To bypass installing the IDERA Dashboard, run the SQLcompliance-x64.exe found in the Installation kit x64 folder. (default location: C:\Program Files\IDERA\SQLcompliance x64 Installation Kit\Full\x64.
6. Run the IDERA SQL Compliance Manager Management Console. Verify the console loads and the servers and data are displayed.
7. Manually update the SQL Compliance Agent on the audited servers.
   1. No agents have been updated yet, so all the servers will report as DOWN (except for the SQL Compliance Agent that is running on the IDERA SQL Compliance Manager Collection server).
   2. Run the SQLcompliance-x64.exe using Run as Administrator (not setup.exe).
   3. Follow the prompts then select Agent Only install.

...