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 computerclustered environment.
   Select the SQL Safe services (:
   • SQLsafe Management Service
   , 
   • SQLsafe Collection Service
   , and 
   • SQLsafe Rest Service
   ) 

   required to configure as a Generic

   Services

   Service Resource.

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

   following

   operation for each one.

5. Select the SQLsafe Management Service and click Next. 

6. On

   the

   the Confirmation

   window

    window, click Next.

7. The wizard configures the service as displayed on

   the

   the Configure Generic Service

   window, and then displays the Summary window.
8. Repeat the steps 3 and 4 with the SQLsafe Collection Service and the SQLsafe Rest Service.
9. Configure your service dependencies. Go to the Roles Section of the  
10. Complete the New Resource Wizard to create the SQLcompliance Collection Service.
11. Right-click the service you just created, and then select Properties.
12. On the General tab, check the Use Network Name for computer name check box.
13. Click Add to add a new root registry key.
14. Type Software\Idera\SQLcompliance, and then click OK.
15. Start the new generic service by bringing the resource online.
16. Open the Windows Failover Cluster Management application named cluadmin.msc.
17. Right-click the application, and then select  Add a resource > 4 - Generic Service.
18. On the Select Service window, wait while the services populate the fields with a list of services installed on this computer.
19. Click SQL Safe Management Service, and then click Next.
20. On the Confirmation window, click Next. The wizard configures the service as displayed on the Configure Generic Service window, and then displays the Summary window.
21. On the Summary window, click Finish.
22. Right-click your new Generic Service resource, and then select Properties. SQL Safe now displays the SQL Safe Management Service Properties window which contains many tabs.
23. On the General tab, check the Use Network Name for Computer Name check box.
24. On the Dependencies tab, add the Network Name and IP Address resources belonging to this application.
25. On the Registry Replication tab, click Add.

26.  window.

27. On the Summary window, click Finish.

28. 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. 

29. SQL Safe now displays the SQL Safe Management Service Properties window.
30. On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of Image Added .
31. Select the Cluster Name and click Apply.
32. Go to General tab, select the box "Use Network Name for computer name" and click Apply.
33. Go the Dependencies tab, click theImage Added scroll down option and select the SQL Server.
34. Click the Image Added scroll down option, select the IP Address, and click Apply.
35. Go to the Registry Replication tab and click Add. 
36. In the Root registry key, type the following text: SoftwareIn the root registry field, type the following text:Software\IDERA\SQL Safe\Management Service
    You can get this path by going to the Registry Editor, open the Local Machine folder - Software - Idera - SQL Safe - Management Service. At the end of the pane, you can see the folder destination path. Copy it on the Root registry key.
37. Click OK.
38. On the SQL Safe Management Service properties window, click Apply, and Ok.
39. Add same dependencies for SQLsafe Collection Service, and SQLsafe Rest Service
40. On the SQL Safe Management Service Properties window, click OK.
41. Repeat the steps 
42. Right-click your new Generic Service resource, and then select Bring this resource online. Your SQL Safe Management Service is now configured for cluster failover.
    

...