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 ways to register the SQL Safe services as a clustered resource:
Creating a new role for the SQL Safe services
Log onto the active cluster node using an Administrator Account.
Launch the Microsoft Failover Cluster Manager.
Right-click on Roles and select Create Empty Role.
Right-click on the newly created role and select Properties.
Rename the role to a unique name (e.g. SQLSafeServices), then click OK.
- Right-click on the role and select Add Resource > Client Access Point.
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.
On the Confirmation screen, click Next.
On the Summary screen, click Finish.
Right-click on the role and select Add Resource > Generic Service.
On the Select Service screen, locate and select the SQL Safe Collection Service. Click Next to proceed.
On the Confirmation screen, click Next.
On the Summary screen, click Finish.
Right-click on the role and select Add Resource > Generic Service.
On the Select Service screen, locate and select the SQL Safe Management Service. Click Next to proceed.
On the Confirmation screen, click Next.
On the Summary screen, click Finish.
Right-click on the role and select Add Resource > Generic Service.
On the Select Service screen, locate and select the SQL Safe Rest Service. Click Next to proceed.
On the Confirmation screen, click Next.
On the Summary screen, click Finish.
Right-click on the newly added Role for the SQL Safe Collection Service and select Properties.
On the Properties window, go to the Dependencies tab.
Add the following dependencies:
- Name of the clustered role.
- IP address.
Click Apply.
Go to the General tab.
Enable the Use Network Name for computer name checkbox, then click OK.
Right-click on the newly added Role for the SQL Safe Management Service and select Properties.
On the Properties window, go to the Dependencies tab.
Add the following dependencies:
- Name of the clustered role.
- IP address.
Click Apply.
Go to the General tab.
Enable the Use Network Name for computer name checkbox, then click Apply.
Go to the Registry Replication tab.
Click the Add button and enter SOFTWARE\Idera\SQLsafe\Management Service into the Root Registry Key field, then click OK.
Adding the SQL Safe services to an existing role
Configuring the SQL Safe Management Service as a Generic Service Resource using Windows Server 2008/ Windows Server 2008 R2 and later
After installing the SQL Safe Management components on your cluster nodes, create the clustered service resource to allow SQL Safe to recognize the cluster nodes.
Use the following steps if you do not have an existing application or service that you want to use for the SQL Safe Management Service.
- Log onto the currently active cluster node using an administrator account, and then start the Microsoft Failover Cluster Manager application named cluadmin.msc .
- Go to Roles on the left side of the pane, select the SQL Server Instance role.
- Right-click on the SQL Server role, and then select Add Resource > Generic Service.
- 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
You cannot perform the operation for all of them at the same time. You have to perform the operation for each one. Select the SQLsafe Management Service and click Next.
On the Confirmation window, click Next .
The wizard configures the service as displayed on the Configure Generic Service window.
On the Summary window, click Finish .
- Repeat these steps for:SQLsafe Collection Service and SQLsafe Rest Service.
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 .
- SQL Safe now displays the SQL Safe Management Service Properties window.
- On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of
. - Select the Cluster Name and click Apply.
- Go to General tab, select the box "Use Network Name for computer name" and click Apply.
- Go the Dependencies tab, click the scroll down option and select the SQL Server.
- Click the scroll down option, select the IP Address, and click Apply.
- Go to the Registry Replication tab and click Add.
- 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. - Click OK.
On the SQL Safe Management Service Properties window, click Apply , and Ok .
Add same dependencies for SQLsafe Collection Service, and SQLsafe Rest Service.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 .
- SQL Safe now displays the SQLSafeCollectionService Properties window.
- On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of .
- Select the Cluster Name and click Apply.
- Go to General tab, select the box "Use Network Name for computer name" and click Apply.
- Go the Dependencies tab, click the scroll down option and select the SQL Server.
Click the
scroll down option, select the IP Address, and click Apply.The SQLSafeCollectionService does not need a Replication Service.- Click OK.
- 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 .
- SQL Safe now displays the SQLSafeRestService Properties window.
- On the Dependencies tab, click on "Click here to add a dependency" and a scroll down list appears under the selection of .
- Select the Cluster Name and click Apply.
- Go to General tab, select the box "Use Network Name for computer name" and click Apply.
- Go the Dependencies tab, click the scroll down option and select the SQL Server.
- Click the scroll down option, select the IP Address, and click Apply.
- Go to the Registry Replication tab and click Add.
- 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. - Click OK.
- On the SQLSafeRestService Properties window, click Apply , and Ok .
- 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 .
Use the following steps if you do have an existing application or service that you want to use for the SQL Safe Management Service.
- Log onto a new cluster node using an administrator account, and then start the Microsoft Failover Cluster Manager application named cluadmin.msc .
- 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.
- 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. - Then, failover your SQL Server Instance.
Right-click on the SQL Server role, and select Move > Select Node. - 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.
If you are going to perform a backup on the Cluster Environment , register all SQL Safe Services as a Generic Service Resource .
Once you configure SQL Safe for the Cluster, you need to update your SQL Safe Management Console settings.
- Launch the SQL Safe Management Console. Go to Tools > Repository and Management Service Settings.
- You get an error message "User preferences repository connnection information is not set", click OK.
The Repository and Management Service Settings window appears.
On the Location of Management Service for this console, sºelect the Change button next to the Computer.
The SQLsafe Preferences window appears, type the hostname or IP Adress for the computer that hosts the SQL Safe Management Service, and click OK.Make sure to type the Cluster name.
- You get an error message "User preferences repository connnection information is not set", click OK.
- On the Repository database for Management Service and Console fill the information with the Clustered SQL Server Instance and Database name.
By default, the Windows Authentication is selected.
If you want to use the Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click save.
Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click OK. - At the bootm of the SQL Safe Management Console you see an alert " There are problems with the Management Service. Clik here for details".
A SQL Safe Management Console window appears saying "This console is configured to use the Management Service installed on the hostname or IP Adress for the computer that hosts the SQL Safe Management Service", click OK. - Go to Tools > Management Console Preferences. On this window, go to User Experience, select the Enable Debug Logging and click OK.