Installing the MS SQL driver

Last Updated : Oct 29, 2025 |

About this task

Use this procedure to install the MS SQL driver if you use Avaya Proactive Outreach Manager with the MS SQL database. To configure the POM database on MS SQL, download the MS SQL driver mssql-jdbc-10.2.0.jre8.jar file from https://www.microsoft.com and install it on the POM system.

Note:

If you have a multiple POM server environment, you must install the MS SQL drivers on all auxiliary POM servers.

Before you begin

  1. Add at least one user with POM-specific privileges.

  2. Install the MS SQL driver to configure the POM database schema on the MS SQL database or use the MS SQL database as a contact data source.

Procedure

  1. Download the mssql-jdbc-10.2.0.jre8.jar MS SQL driver from https://www.microsoft.com.
    Note:

    If you cannot to find the jar file on https://www.microsoft.com, copy the file from the machine where Avaya Experience Portal is installed, from the location opt/Tomcat/apache-tomcat-8.5.57/common/lib/mssql-jdbc-10.2.0.jre8.jar. Ensure to copy or download the correct jar file.

  2. Log in to Linux on the EPM server as a user with root or sroot privileges.
  3. Create a folder ~/POMMssqlJDBC by running the command: mkdir —p ~/POMMssqlJDBC.
  4. Copy the driver files mssql-jdbc-10.2.0.jre8.jar to the folder ~/POMMssqlJDBC.
  5. To install the JDBC driver, type the following bash command:

    $POM_HOME/bin/InstallPOMMsSqlJDBC.sh

    Important:

    Some web browsers change the file name extension of these files to .zip, when you download the files. Then, rename the file to mssql-jdbc-10.2.0.jre8.jar.

    Keep the MS SQL JDBC driver files in the folder ~/POMMssqlJDBC even after installing or upgrading Avaya Experience Portal. You need these files when you install or upgrade POM.