Versions Compared

Key

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

Registering the SQL Safe services with Microsoft Failover Cluster Manager allows the Microsoft Cluster Service to manage the services in failover situations. The following configuration ensures the high availability of the services during a failover.

There are two separate set of instructions that can be followed ways to register the SQL Safe services as a clustered resource:

...

  1. Log onto the active cluster node using an administrator account and then launch Administrator Account.

  2. Launch the Microsoft Failover Cluster Manager.

  3. Right-click on Roles and select Create Empty Role.

  4. Right-click on the newly created role and select Properties.

  5. Rename the role to a unique name (e.g. SQLSafeServices), then click OK.

  6. Right-click on the role and select Add Resource > Client Access Point.
  7. On the Client Access Point screen, enter a unique Network Name (e.g. SQLSafeCluster) and an available IP Address that has been reserved for the clustered resource, then click Next.

  8. On the Confirmation screen, click Next.

  9. On the Summary screen, click Finish.

  10. Right-click on the role and select Add Resource > Generic Service.

  11. On the Select Service screen, locate and select the SQL Safe Collection Service. Click Next to proceed.

  12. On the Confirmation screen, click Next.

  13. On the Summary screen, click Finish

  14. Right-click on the role and select Add Resource > Generic Service.

  15. On the Select Service screen, locate and select the SQL Safe Management Service. Click Next to proceed.

  16. On the Confirmation screen, click Next. 

  17. On the Summary screen, click Finish

  18. Right-click on the role and select Add Resource > Generic Service.

  19. On the Select Service screen, locate and select the SQL Safe Rest Service. Click Next to proceed.

  20. On the Confirmation screen, click Next.

  21. On the Summary screen, click Finish.

  22. Right-click on the newly added Role for the SQL Safe Collection Service and select Properties.

  23. On the Properties window, go to the Dependencies tab.

  24. Add the following dependencies:

    1. Name of the clustered role.
    2. IP address.
  25. Click Apply.

  26. Go to the General tab.

  27. Enable the Use Network Name for computer name checkbox, then click OK.

  28. Right-click on the newly added Role for the SQL Safe Management Service and select Properties.

  29. On the Properties window, go to the Dependencies tab.

  30. Add the following dependencies:

    1. Name of the clustered role.
    2. IP address.
  31. Click Apply.

  32. Go to the General tab.

  33. Enable the Use Network Name for computer name checkbox, then click Apply.

  34. Go to the Registry Replication tab.

  35. Click the Add button and enter SOFTWARE\Idera\SQLsafe\Management Service into the Root Registry Key field, then click OK.




Anchor
existingrole
existingrole
Adding the SQL Safe services to an existing role

...