Page History

...

1. Log onto the currently active cluster node using an administrator account, and then start the Microsoft Failover Cluster Manager application named named cluadmin.msc.
2. Go to Roles on the left side of the pane, select the SQL Server Instance role.
3. Right-click on the SQL Server role, and then select Add Resource > Generic Service.
4. The Select Service wizard opens with a list of all services installed on the clustered environment.
   Select the SQL Safe services required to configure as a Generic Service Resource:
   • SQLsafe Management Service
   • SQLsafe Collection Service
   • SQLsafe Rest Service
   tip

   Info
   You cannot perform the operation for all of them at the same time. You have to perform the operation for each one.
   If you are going to perform a backup on the Cluster Environment, register all SQL Safe Services as a Generic Service Resource.

5. Select the SQLsafe Management Service and click Next. 

6. On the Confirmation window, click Next.

7. The wizard configures the service as displayed on the Configure Generic Service window.

8. On the Summary window, click Finish.

9. Repeat these steps for:SQLsafe Collection Service and SQLsafe Rest Service.

10. Then, go to Roles on the right side of the pane. Right-click on your new Generic Service Resource (SQLsafe Management Service), and then select Properties. 

11. SQL Safe now displays the SQL Safe Management Service Properties window.
12. On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of  .
13. Select the Cluster Name and click Apply.
14. Go to General tab, select the box "Use Network Name for computer name" and click Apply.
15. Go the Dependencies tab, click the scroll down option and select the SQL Server.
16. Click the  scroll down option, select the IP Address, and click Apply.
17. Go to the Registry Replication tab and click Add. 
18. In the Root registry key, type the following text: SOFTWARE\Idera\SQLsafe\Management Service
    You can get this path by going to the Registry Editor, open the LOCAL MACHINE folder - SOFTWARE- Idera - SQLsafe - Management Service. At the end of the pane, you can see the folder destination path. Copy it on the Root registry key.
19. Click OK.

20. On the SQL Safe Management Service Properties window, click Apply, and Ok.

    Info
    Add same dependencies for SQLsafe Collection Service, and SQLsafe Rest Service.

21. Go to Roles on the right side of the pane. Right-click on your new Generic Service Resource (SQLsafe Collection Service), and then select Properties. 

22. SQL Safe now displays the SQLSafeCollectionService Properties window.
23. On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of  .
24. Select the Cluster Name and click Apply.
25. Go to General tab, select the box "Use Network Name for computer name" and click Apply.
26. Go the Dependencies tab, click the scroll down option and select the SQL Server.

27. Click the  scroll down option, select the IP Address, and click Apply.

    Tip
    This service does not need a Replication Service.

28. Click OK.
29. Go to Roles on the right side of the pane. Right-click on your new Generic Service Resource (SQLsafe Rest Service), and then select Properties. 
30. SQL Safe now displays the SQLSafeRestService Properties window.
31. On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of  .
32. Select the Cluster Name and click Apply.
33. Go to General tab, select the box "Use Network Name for computer name" and click Apply.
34. Go the Dependencies tab, click the scroll down option and select the SQL Server.
35. Click the  scroll down option, select the IP Address, and click Apply.
36. Go to the Registry Replication tab and click Add. 
37. In the Root registry key, type the following text: SOFTWARE\Idera\SQLSafeRestService
    You can get this path by going to the Registry Editor, open the LOCAL MACHINE folder - SOFTWARE - Idera - SQLSafeRestService. At the end of the pane, you can see the folder destination path. Copy it on the Root registry key.
38. Click OK.
39. On the SQLSafeRestService Properties window, click Apply, and Ok.
40. Then, go to Roles on the right side of the pane. Right-click on your new Generic Service Resource (SQLsafe Management Service), and select Bring Online. Do the same for SQLsafe Collection Service, and SQLsafe Rest Service.

...

1. Log onto a new cluster node using an administrator account, and then start the Microsoft Failover Cluster Manager application named cluadmin.msc.
2. Go to Roles on the left side of the pane, select the SQL Server Instance role that is the same as the one you used on the other node.
3. On the Resources tab you can see the resource services added on the other node.
   If you want to add more resource services, follow the steps specified above. You only have to make sure to specifiy the dependencies and regisrty replication.
4. Then, failover your SQL Server Instance.
   Right-click on the SQL Server role, and select Move > Select Node.
5. The Move Clustered Role wizard appears. Select your Cluster Node and click OK.
   All your resources configured on the other node are transferred to the new node.

...