Versions Compared

Key

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

...

Note

Before upgrading, changing, or uninstalling SQL Compliance Manager on the passive node, you must delete the following registry entry: HKEY_LOCAL_MACHINE\Software\Idera\SQLcompliance\CollectionService\TraceDirectory. This step is unnecessary for new installations.

To install SQL Compliance Manager services on cluster nodes:

  1. Log on with an administrator account to the computer on which you want to install SQL Compliance Manager.
  2. Run SQLCMInstall.exe in the root of the SQL Compliance Manager installation kit on the first cluster node.
  3. Review the information you need to start the installation and click Next.
  4. Select the SQL Compliance Manager setup type and uncheck the IDERA Dashboard setup type.

    Warning

    The IDERA Dashboard does not provide support for clustered environment installations. If you want to use the IDERA Dashboard, review Deploy the IDERA Dashboard in a clustered environment.

    Review and accept the license agreement by selecting the I accept the terms and conditions of the End User License Agreement checkbox. 

  5. Specify if you want to register SQL Compliance Manager with an existent IDERA Dashboard. 
    If you select Yes, you need to provide the IDERA Dashboard location and administrator credentials. If you want to use the IDERA Dashboard, see how to Deploy the IDERA Dashboard in clustered environments
  6. Specify the location in which you want to install SQL Compliance Manager.
  7. Enable the Clustered Environment checkbox and select whether you are installing SQL Compliance Manager in an active or a passive node. 
    Specify a SQL Server Instance and a form of authentication to create the SQL Compliance Manager repository. 
    Test the connections to make sure the information is correct and click Next.
  8. If you install on the currently active node, specify a trace directory on a shared disk, and then click Next
    If you install on a passive node, the wizard skips this step.
  9. Type the appropriate credentials in the provided fields under which the IDERA services run, and then click Next
    IDERA uses this account to connect, discover, and gather configuration information from SQL Servers in your Business environment, the installer grants the "Log on as a Service" right to the account that you specify.
  10. Review the installation settings and click Install.
  11. In Windows Services, stop the SQL Compliance Manager Collection service and set the Startup type to Manual.

...

Once the installation of SQL Compliance Manager is completed, proceed to Register the SQL Compliance Manager Collection service Service as a clustered resource.

Note

SQL Compliance Manager is ONLY compatible with IDERA Dashboard version 4.6 and with limited support.

Scroll pdf ignore
Newtabfooter
IDERA Website | Products Buy Support Community About Us | Resources Legal
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse