Using CMS with Microsoft SQL Server
- Create new database in Microsoft SQL Server
- Create user account to access the database
- Open Genesys Administrator and navigate to Provisioning > Environment > Applications
- Select the application defined for the Knowledge Center Cluster and click Edit
- From the Options tab in the cms.cluster section, set the following options:
Importantif you are using version 8.5.300.xx, please type jdbc instead of mssql
- set option type to value mssql
- set dbConnectionUrl to JDBC connection string for connection to MS SQL Server following the format:
jdbc:jtds:sqlserver://<host_of_MSSQL_Server>:<port_of_MSSQL_Server, 1433 by default>;databaseName=<CMS_DB_name>
- dbUsername - set to the username that needs to be used to login to MS SQL Server
- dbPassword - set to the password for db account
- dbDriverClass - set to net.sourceforge.jtds.jdbc.Driver
ImportantDescription of options in cms.cluster section can be found in Configuration Options.
If you are installing Knowledge Center CMS 8.5.302.xx or earlier, you need to download and place Microsoft SQL Server JDBC driver on every CMS host:
- Open in your browser https://sourceforge.net/projects/jtds/files/jtds/1.2.7/
- Download jtds-1.2.7-dist.zip (Oracle account is needed)
- Unpack downloaded archive
- Place jtds-1.2.7.jar into <CMS_installation_folder>/lib/ext
ImportantThe driver must be added to the installation folder of every CMS node in your deployment.
Starting from the 8.5.303.xx release of the product, drivers are embedded into the CMS's IP.
This page was last edited on October 16, 2017, at 18:03.