Page History

...

1. Log onto the currently active 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.
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:
   • SQLsafe Management Service
   • SQLsafe Collection Service
   • SQLsafe Rest Service

   required to configure as a Generic Service Resource.

   Info
   You cannot perform the operation for all of them at the same time. You have to perform the operation for each one.

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 Go to Roles on the right side of the pane. Right-click on your new Generic Service Resource (ex. 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 SOFTWARE\IDERAIdera\SQL SafeSQLsafe\Management Service
    You can get this path by going to the Registry Editor, open the Local Machine LOCAL MACHINE folder - Software SOFTWARE- Idera - SQL Safe 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

     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 Image Added .
24. Select the Cluster Name and click Apply.
25. Go to General tab, select the SQL Safe Management Service Properties window, click OK.
26. Repeat the steps 
27. box "Use Network Name for computer name" and click Apply.
28. Go the Dependencies tab, click theImage Added scroll down option and select the SQL Server.

29. Click the Image Added scroll down option, select the IP Address, and click Apply.

    Tip
    This service does not need a Replication Service.

30. Click OK.
31. 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. 
32. SQL Safe now displays the SQLSafeRestService Properties window.
33. On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of Image Added .
34. Select the Cluster Name and click Apply.
35. Go to General tab, select the box "Use Network Name for computer name" and click Apply.
36. Go the Dependencies tab, click theImage Added scroll down option and select the SQL Server.
37. Click the Image Added scroll down option, select the IP Address, and click Apply.
38. Go to the Registry Replication tab and click Add. 
39. In the Root registry key, type the following text: SOFTWARE\Idera\SQLSafeRestService
40. 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.
41. Click OK.
42. On the SQLSafeRestService Properties window, click Apply, and Ok.
43. 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 ServiceRight-click your new Generic Service resource, and then select Bring this resource online. Your SQL Safe Management Service is now configured for cluster failover.
    

...