Configuring Multi-Subnet Failover Connectivity for the WebMarshal Database

This article applies to:

• WebMarshal 7.5.5 and above
• Database connectivity

Question:

• How do I configure Multi-Subnet Failover for the WebMarshal database connection?

Procedure:

First, configure the database using the WebMarshal Console

To add Multi-Subnet Failover:

1. On the Array Manager server, in the WebMarshal install edit the file ArrayManager\Policy\ArrayPolicy.Working.xml
2. Locate the node "Database"
3. Add an attribute useMultiSubnetFailover and set the value to "yes"; For example:
   <Database useMultiSubnetFailover="yes" provider="MSOLEDBSQL" server="somecluster" database="WebMarshal" user="EXAMPLE\Secureuser" password="6X+NAW/fiu/egydom+4j4A==" useTCP="yes"  enabled="yes" retention="100" reportingConsole="" />
4. Do not edit the other values. Note that XML values are case sensitive.
5. Save the file, and the restart the WebMarshal Array Manager service

Notes:

Be aware that the Marshal Reporting Console does not support Multi-Subnet Failover. Database connections from MRC must be configured for a single server.