Jump to: navigation, search

MS SQL Cluster Database with MultiSubnet Listener for Framework Applications

This section describes how to configure the MS SQL Always On with MultiSubnet Listener feature for the Configuration Server (for the Configuration Database) and Message Server (for the Centralized Log Database) applications. No configuration is required for DB Server.

For more information about the feature, refer to MS SQL Always On with MultiSubnet Listener in the Framework Database Connectivity Reference Guide.

Configuration Server

You must be sure that you are using the correct dbclient. On the Windows platform, you must use the dbclient_msql located in the dbclient_next folder of the latest IP. On the Linux platform, you can use the default dbclient_msql.

Use the mssql-multisubnet option to enable the feature. This feature enables multisubnet failover using MS SQL for disaster recovery and business continuity scenarios involving the Configuration Database. For more information about this option, see the Configuration Server Release note for version 8.5.101.22.

In Configuration Server, add [<Configuration Database section>].mssql-multisubnet=Yes in the configuration file (confserv.cfg or confserv.conf), as shown in the following example. Note that you can specify either the listener name or IP address for the dbserver parameter.

[dbserver]
dbengine = mssql
dbserver = 135.17.38.30
dbname = db01
username =sa
password =Genesys#1
mssql-multisubnet=Yes

Message Server

You must be sure that you are using the correct dbclient. On the Windows platform, you must use dbclient_msql located in the dbclient_next folder of the latest IP. On the Linux platform, you can use the default dbclient_msql.

Use the mssql-multisubnet option to enable the feature. This feature enables multisubnet failover using MS SQL for disaster recovery and business continuity scenarios involving the Centralized Log Database.

In the Database Access Point (DAP) application connecting Message Server to the Log Database, use Genesys Administrator to set the [default].mssql-multisubnet option to Yes.

Refer to Database Access Points in the Framework Database Connectivity Reference Guide for instructions about configuring a DAP. For more information about the option, see the Message Server Release note for version 8.5.100.19.

This page was last modified on October 8, 2019, at 19:28.

Feedback

Comment on this article:

blog comments powered by Disqus