Clustering ConnectR

Before you begin you must install the cluster and SQL server properly and ensure they are working normally on each node. Set the Lock Pages in Memory setting for the service account you are using.

Steps

1. Install ConnectR 4.5 following the above steps onto each node. The serverdefinition table uses the SQL Server instance.
2. Roll the cluster groups onto the active node you are installing into.
3. Ensure it is working properly on each node.
4. To cluster set the Service to start manually on each node.
5. Open cluster admin and create the following resource in the SQL Group.
6. This must be in the same cluster group as the network name that is being used. This should be the SQL Server instance name.
7. This service must be brought online and offline using cluster administrator. It will give you an error if you do it in the application.
8. Setup and cluster the IDXConnectR service resource:

Type: Generic Service
Dependency: SQL Server
Service Name: IDXConnectR System Service4.0
Parameters: Check the box to Use Network Name as computer name
Registry Options: No Registry Copying, just click finish

Registry Settings

Registry settings that have to exist for System Service to fail over correctly on a cluster:

• System Service Config (Front End) has to be saved on both nodes to save DSN, username and password to registry on each node. These 3 keys should match on both nodes. You should also verify the DSN to be setup correctly as well.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\IDXConnectR System Service4.0\Parameters\Datasource
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\IDXConnectR System Service4.0\Parameters\Password
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\IDXConnectR System Service4.0\Parameters\Username

• This key should also exist for a cluster: (populated by running the CXR cluster setup Front end or batch file)

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\IDXConnectR System Service4.0\Environment

• If the ConnectR server does not have sql running you need to disable that dependence.

1. On both nodes open the registry.
2. Add the key.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\IDXConnectR System Service4.0\Parameters\NoDependencyFlag 
DWORD value = 1.

Troubleshooting

Symptoms: Interfaces will not start.

Cause: If the Connectr server is part of a cluster, and it does not have sql you must remove the dependency on sql

Resolution: Registry settings that have to exist for System Service to fail over correctly on a cluster. See above.

ConnectR