Setting Up Replication Agent for Microsoft SQL Server on Windows Server Failover Clustering

Set up Replication Agent for Microsoft SQL Server on a shared disk and add it as a generic application on the Windows Server Failover Clustering (WFSC) cluster.

Prerequisites

Before installing Replication Agent for Microsoft SQL Server, setup and configure the WSFC cluster and Microsoft SQL Server.

See the Windows Server Failover Clustering with SQL Server documentation available at http://technet.microsoft.com/en-us/library/hh270278.aspx .
Make sure at least one shared disk is available in the Microsoft SQL Server Cluster service for sharing data between Microsoft SQL Server and the Replication Agent instance.

See the Create a New SQL Server Failover Cluster documentation available at http://technet.microsoft.com/en-us/library/ms179530.aspx .

Software Requirements

Windows Server Failover Clustering (WSFC) on Windows Server 2008 R2
Microsoft SQL Server 2008 R2
Replication Agent 15.7.1 SP110 or later

Supported Configurations

Replication Agent 15.7.1 supports only the Instance-level High Availability cluster configuration of Microsoft SQL Server. Replication Agent does not support the Database-level High Availability (an availability group) cluster configuration.

Task

Install the Replication Agent on the primary cluster node.
See the Replication Agent Installation Guide for the installation information.
Verify that the %SYBASE% installation directory is on a shared disk that is part of the Microsoft SQL Server Cluster service.
Create the sybfilter configuration file on a persistent system disk.
During the instance initialization, set verify_sybfilter to no in the resource file.
Complete these steps on the remaining cluster nodes:
1. Set the %SYBASE% directory to the existing installation location on the shared disk manually.
2. Install the SQL Server JDBC Driver and configure the %CLASSPATH%.
  See Installing the Microsoft SQL Server JDBC Driver in the Replication Server Options Quick Start Guide.
3. Install and set up the sybfilter driver.
  For the detailed instructions, see Installing and Setting Up the sybfilter Driver.
Add the Replication Agent instance as a 'Generic Application' to the Microsoft SQL Server Cluster service with this command:
```
%SYBASE%\RAX-15_5\bin\ra.bat
```
```
-i <instance_name> -replicate
```
where:
- %SYBASE% – is the Replication Agent installation directory.
- instance_name – is the name of your Replication Agent instance.
- replicate – is the name of your replicate Replication Server.
After running this command successfully, a generic application is added in the Microsoft SQL Server Cluster service.
To add a dependency to the 'SQL Server' for a generic application:
1. In the Microsoft SQL Server Cluster, right-click on the Generic Application and select Properties.
2. In the Properties dialog, select Dependencies tab, and click the Insert button.
3. Select SQL Server from the drop-down list, and click OK.