How to install SQL Compliance Manager

Pre -Installation 

Before installing IDERA SQL Compliance Manager, consider the following best practices:

• Ensure you review the hardware, software, permissions, and port requirements.
• Decide whether you should install the Collection Server on a dedicated SQL Server instance.
• A SQL Server instance to host the IDERA SQL CM and the IDERA Dashboard repository databases.
• Have valid Service Account credentials for the IDERA Services. 
• If you plan to audit instances running SQL Server 2005 or later, install the Collection Server on a computer hosting the highest version of SQL Server running in your environment. For example, to accept event data from audited instances running SQL Server 2012, the Repository databases must reside on a SQL Server 2012 or higher instance.

By default, SQL Compliance Manager installs with a trial license. For more information about trial licenses or upgrading your license, see Licensing.

Fresh Installation

Install Features

1. Select the Fresh Installation option.
   
   
   
   
2. Accept the terms and conditions of the EULA and click Next. 
   1. Click the link to open the EULA dialog to review it in detail.
3. Select the features you want to install and click Next.
   1. SQL Compliance Manager - Installs the collection service, the management console, and the agent components. 
   2. SQL Compliance Manager Management Console - installs the application only.
   3. SQL Compliance Manager Agent Components - installs the agent service and its required components only.
   4. IDERA Dashboard - installs the IDERA Dashboard that can be accessed via web console to access SQL CM.
      
      

Dashboard Registration

Select if you want to register SQL CM with an existing IDERA Dashboard.

Register the IDERA Dashboard locally - type in the Dashboard Location where you want to install the IDERA Dashboard and type in your Administrator Credentials.

1. Choose whether you want to register SQL CM to an existing IDERA Dashboard. If you choose Yes, follow the steps below. If you choose No, click Next.
   
   
   
   
   1. Select whether to register SQL CM with the IDERA Dashboard locally or on a remote server. 
   2. In the text field type in the Remote IDERA Dashboard Location addressed. If you selected to register locally, the address fills in automatically.
   3. Fill in the text fields with your UserName and Password and click Next. 

Installation Directory

1. Type in or browse the installation folder where you want to install SQL CM.
2. Type in a Display Name to be shown on the IDERA dashboard for the current installation. 

Repositories

If you want to enable a Clustered Environment. Select the checkbox and choose between an Active Node or a Passive Node to create your repositories. 

Create SQL Compliance Manager Repository

Select your SQL Server Instance from the drop-down menu. 

Select the authentication method. When selecting Use Microsoft SQL Server Authentication, a screen prompts you to add the Username and Password.

Trace Directory

Select where you want to store the audit information obtained with the SQLCompliance Agents before it processes the information and sends it into the Repositories.

Service Account

Specify the account used for IDERA Services.

Summary

Review the stated parameters before the installation.

Press the Install button to start the installation.

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal