IDERA SQL Compliance Manager 5.4 depends on certain Microsoft components that did not ship with SQL Server versions prior to SQL Server 2012 SP1. If you are installing SQL Compliance Manager's Collection Service on a Repository running on SQL Server 2012 or below, you must install these components manually. For more information about this process, see Important installation steps for SQLCM 5.4.x.
Installing IDERA SQL Compliance Manager is both quick and easy, allowing you to take immediate advantage of SQL Compliance Manager auditing technologies. Use the following checklist to help you prepare your environment to successfully install and deploy SQL Compliance Manager.
|Follow these steps ...|
Ensure the computer on which you want to install SQL Compliance Manager meets or exceeds the hardware requirements. For more information, see Hardware requirements.
|Ensure the computer on which you want to install SQL Compliance Manager meets or exceeds the software requirements for both the IDERA Dashboard and SQL Compliance Manager. For more information, see IDERA Dashboard requirements and Software requirements.|
Ensure your Windows logon account has administrator permissions on the computers where you want to install SQL Compliance Manager components.
|Review the supported installation scenarios to understand how to set up IDERA Dashboard and SQL Compliance Manager in your environment. For more information, see Implementation scenarios.|
|Review the deployment considerations for implementation best practices. For example, if you plan to audit databases that sustain a heavy workload, install the Collection Server on a dedicated computer.|
Identify the Windows account under which the SQL Compliance Agent should run.
|Identify the Windows account under which the Collection Server should run. |
For more information, see Permissions requirements.
|Ensure you understand how licensing of your SQL Server instances works with SQL Compliance Manager. For more information, see How licensing works.|
|Ensure you install IDERA Dashboard and SQL Compliance Manager as instructed. For more information, see How to install SQL Compliance Manager. If you are installing SQL Compliance Manager on a Windows cluster, see how to audit a virtual SQL Server instance.|