Page History

You can upgrade the SQL Server software running on the existing Collection Server when you use your current IDERA SQL Compliance Manager installation to audit instances running on multiple versions of SQL Server at the same time in a single environment. Use the following checklist and instructions to successfully upgrade the SQL Server software.

Upgrade checklist

Image Removed

Image Added	Follow these steps ...

Image Removed

Image Added

Determine whether you want to upgrade to the latest version of SQL Compliance Manager. To verify whether you are running the latest version, click Check for Updates on the Help menu.

Image Removed

Image Added

Choose the

appropriate

appropriate upgrade strategy for your environment and your auditing needs.

Image Removed

Image Added

Ensure your Windows logon account has administrator permissions on the Collection Server computer and sysadmin rights on the SQL Server instance hosting the Repository.

Image Removed

Image Added	Back up your trace directories, especially the Collection Server Trace Directory.
Image Added	Run the Microsoft SQL Server Upgrade Advisor utility on the target instance. For

example, for

more information about upgrading

to

SQL Server

2008

, see Newtablink alias Upgrade Advisor url https://docs.microsoft.com/en-us/sql/sql-server/install/use-upgrade-advisor-to-prepare-for-upgrades?view=sql-server-2014&viewFallbackFrom=sqlallproducts-allversions on the

Microsoft Solutions Web site (http

Newtablink alias Microsoft web site url https://www.microsoft.com

/sqlserver

/

2008/

en-us/

us/solutions.aspx)

sql-server/ .

Upgrade instructions

1. If you want to use the latest version of SQL Compliance Manager, upgrade your deployment Upgrade to this build.
2. Disable auditing at on a SQL Server at the server level.
3. Stop the SQLcompliance SQL Compliance Manager Agent service. Use the Microsoft Services administrative tool to stop the SQLcompliance SQL Compliance Manager Agent service (SQLcompliance SQL Compliance Manager Agent) running on the Collection Server computer.
4. Stop the Collection Server service. Use the Microsoft Services administrative tool to stop the Collection Server service (SQLcompliance SQL Compliance Manager Collection Service) running on the Collection Server computer.
5. Upgrade SQL Server on the Collection Server computer.
6. Restart the Collection Server service. Use the Microsoft Services administrative tool to restart the Collection Server service (SQLcompliance Collection Service) running on the Collection Server computer.
7. Restart the SQLcompliance SQL Compliance Manager Agent service. Use the Microsoft Services administrative tool to restart the SQLcompliance SQL Compliance Manager Agent service (SQLcompliance SQL Compliance Manager Agent) running on the Collection Server computer.
8. If you upgraded SQL Compliance Manager to the latest version, also upgrade the deployed SQLcompliance SQL Compliance Manager Agent remotely. 
9. Upgrade the SQL Server software on the computers hosting your audited instances.
10. Begin auditing any  any new SQL Server instances.

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

...