Versions Compared

Key

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

...

  1. In the Microsoft Cluster Administrator tool (Windows Server 2003) or Microsoft Failover Cluster Management Console (Windows Server 2008 and later), select the SQLComplianceCollectionService resource and take the service offline.
  2. Log on with an administrator account to the computer on which you want to upgrade SQL Compliance Manager.
  3. Run SQLCMInstall.exe in the root of the SQL Compliance Manager installation kit on the first cluster node.
  4. Review the information you need to start the upgrade and click Next.
  5. Select the SQL Compliance Manager setup type and uncheck the IDERA Dashboard setup type. Review and accept the license agreement by selecting the I accept the terms and conditions of the End User License Agreement checkbox. 

  6. Specify if you want to register SQL Compliance Manager with an existent existing 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.  
  7. Specify the location in which you want to upgrade SQL Compliance Manager.
  8. Enable the Clustered Environment checkbox and select whether you are upgrading SQL Compliance Manager in an active or a passive node. 
    Verify that the repository is the same SQL Server Instance name hosting the current repository and specify a form of authentication.
    Test  Connections to make sure the information is correct and click Next.
  9. If you upgrade on the currently active node, verify that the trace directory is the same location in which your current directory resides, and click Next
    If you upgrade on a passive node, the wizard skips this step.
  10. 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.
  11. Review the upgrade settings and click Install.
  12. In Windows Services, stop the SQL Compliance Manager Collection service and set the Startup type to Manual.

...

  1. Log on to the active node and launch the Microsoft Cluster Administrator tool (Windows Server 2003) or the Microsoft Failover Cluster Management Console (Windows Server 2008 and later), right-click the SQLComplianceCollectionService resource, and select Properties. 
  2. Go to the Registry Replication tab and set the Root Registry Key to Software\Idera\SQLCM.
  3. Close the Properties window, right-click the SQLComplianceCollectionService resource, and bring the service online.
  4. Log on to the passive node, launch the Microsoft Cluster Administrator tool (Windows Server 2003) or the Microsoft Failover Cluster Management Console (Windows Server 2008 and later), and verify if the SQLComplianceCollectionService resource is online.   


Note

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

Scroll pdf ignore
Newtabfooter
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