Versions Compared

Key

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

...

Below you can find a set of instructions to register the SQL Compliance Manager services as a clustered resource:

Adding SQL Compliance Manager Collection service to an existing role

After finishing the installation in all nodes, go to the active node and follow the steps below. 

  1. Open the Microsoft Failover Cluster Manager and select Roles
  2. Right-click on the SQL Server role, point to Add Resource, and select Generic Service




  3. Microsoft Failover Cluster Manager displays the New Resource Wizard
  4. Select SQLcompliance Collection Service, click Next, review the generic service configuration summary, and click Finish
  5. In the Roles section, right-click the SQLcompliance Collection Service, and select Properties



  6. On the General tab, check the Use Network Name for computer name box, and click Apply

    Info

    If this action throws an error, try again after configuring the following information:

    Go to the Dependencies tab, add the following resources: SQL Server and SQL Server Agent, and click Apply.

  7. On the Registry Replication tab, click Add
  8. Type Software\Idera\SQLcompliance SQLCM and click OK

    Note

    The Registry Replication tab is not available in Windows Server 2012.

    If you are using Windows Server 2012, you must use the "Add-ClusterCheckpoint" PowerShell cmdlet to add the necessary setting.

    For more information, see

    Newtablink
    aliasAdd ClusterCheckpoint
    urlhttps://docs.microsoft.com/es-es/previous-versions/windows/powershell-scripting/hh847255(v=wps.620)
    .

  9. In the Roles section right-click the SQLcompliance Collection Service and Bring the resource Online



  10. Open the Microsoft Failover Cluster Manager on the other nodes and verify if the SQLcompliance Collection Service is online. 

...

After registering the collection service as a clustered resource, proceed to install the IDERA Cluster Configuration Console to configure the SQLcompliance SQL Compliance Manager Agent.   



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
IDERA Website | Products Buy Support Community About Us | Resources Legal