To enable secure connections from Avaya Context Store Snap-in to External Data Mart (EDM), you must set the appropriate values on System Manager.
Before you begin
If you are using a third-party certificate, do the following:
Export the TLS certificate from the MS SQL server.
Import the certificate to the truststore of each Avaya Breeze® node from the MS SQL server.
Procedure
In System Manager, click Elements > Avaya Breeze® > Configuration > Attributes.
In the Attributes Configuration page, click the Service Clusters tab and do the following:
In Cluster, select the name of the Provisioning Cluster.
In Service, select OceanaConfiguration.
In the External Data Mart Configuration section, ensure that the value of Secure Connections to EDM is set to true.
In External Data Mart FQDN, type the FQDN of the EDM database host for the TLS connection.
If connecting to an availability group of EDMs, type the FQDN of the AlwaysOn Availability Group Listener. Do the following to find the FQDN of the AlwaysOn Availability Group Listener:
Log on to the primary or secondary SQL Server as the domain user configured for use with the SQL Server Service.
Open SQL Server Management Studio.
Login to the SQL instance as the domain user configured for use with the SQL Server Service.
To find the name of the Availability Group Listener, click Always On High Availability > Availability Groups > <The name of the EDM Availability Group> > Availability Group Listeners.
The FQDN is the name of the Listener and the name of the domain to which the SQL Server cluster belongs to. For example, myListener.exampleDomain.com.
Important:
You must enter the FQDN of the host for secure connections. Do not enter the IP address.