Page tree

You can quickly and easily upgrade to this version of SQL Compliance Manager from version 2.0 or later. Upgrading SQL CM allows you to take advantage of the new features available in this latest version.

Upgrade checklist

(tick)Follow these steps ...
(tick)

Ensure the computers on which you want to upgrade SQL Compliance Manager meet or exceed the hardware, software, and permissions requirements for this version. For example, ensure .NET Framework 2.0 or later is running on the target computer.

(tick)

Ensure your Windows logon account has local administrator permissions on the computers you intend to upgrade.

(tick)

Close all open applications on the computers running the SQL CM components.

(tick)Back up your trace directories, especially the Collection Server Trace Directory.
(tick)

Upgrade your SQL Compliance Manager Repository, Collection Server, and Console.

(tick)

When prompted, schedule a time for SQL Compliance Manager to perform maintenance on your Repository databases.

(tick)

Ensure your product license is current. If you are upgrading from version 2.1 or earlier, you will need to upgrade your license key.

(tick)

Upgrade your previously deployed SQLcompliance Agents.

(tick)

Ensure your upgrade includes any new reports by redeploying the SQL Compliance Manager reports If you are upgrading from version 3.0 or earlier and you use Microsoft Reporting Services, you must redeploy the SQL CM Reports in order to generate reports using the upgraded Repository databases as the data source.

(tick)

Test your upgrade by collecting and reporting on your audit data.

 

SQL Compliance Manager audits all activity on your server. Learn more > >