App Control Server: How to configure SQL Server MultiSubnetFailover Property

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

How to configure the SQL Server MultiSubnetFailover connection property for Always-On-Availability groups?

Environment

• App Control Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions

Resolution

1. If there is an App C Agent installed on the App C server, please disable tamper protection first
2. Find and edit this file: C:\Program Files (x86)\Bit9\Parity Server\shepherd.dsn
3. Add the following line at the bottom of the document:

   MultiSubnetFailover=Yes

4. Find and edit the "ConnectionInfo" section of this file: C:\Program Files (x86)\Bit9\Parity Console\WebUI\PEAR\DB\sqlsrv.php
5. Add the line 'MultiSubnetFailover'=> 'yes' before the closing parenthesis, so it looks like:

   $connectionInfo =
   array(
   'DATABASE' => $dsn['database'] ? $dsn['database'] : null,
   'ReturnDatesAsStrings' => false, // Use custom formatting, bcs no way to configure built-in formatting
   'CharacterSet' => $this->_charset,
   'LoginTimeout' => $this->_logintimeout,
   'MultiSubnetFailover'=> 'yes'
   )

6. Restart the App Control services
7. Please validate the content of sqlsrv.php after every server upgrade as the file may get overwritten