Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

(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 4.0 or later is running on the target computer.

(tick)

Ensure your Windows logon account has the following permissions:

  • Permission to agent and collection trace file directories
  • Permission to uninstall/install a windows service
  • Permission to start a service (Logon as a service)
(tick)

Close all open applications on the computers running the SQL Compliance Manager 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)

Upgrade your license key.

(tick)

Upgrade your previously deployed SQL Compliance Agents.

(tick)

Ensure that 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 Compliance Manager Reports in order to generate reports using the upgraded Repository databases as the data source.

(tick)

Ensure that the computers on which you want to upgrade SQL Compliance Manager have VC redistributable 2010 installed. You can download the Microsoft Visual C++ 2010 Redistributable Package for 32 Bit OS (x86)

Newtablink
aliashere
urlhttps://www.microsoft.com/en-us/download/details.aspx?id=5555
, and the Microsoft Visual C++ 2010 Redistributable Package for 64 Bit OS (x64)
Newtablink
aliashere
urlhttps://www.microsoft.com/en-in/download/details.aspx?id=1463226999
.

(tick)

Ensure that the computers on which you want to upgrade SQL Compliance Manager have the latest version of Microsoft Windows Installer Driver installed. You can find and download the latest Windows Installer

Newtablink
aliashere
urlhttps://docs.microsoft.com/en-us/windows/desktop/Msi/what-s-new-in-windows-installer
.

(tick)Test your upgrade by collecting and reporting on your audit data.

...