Jama Connect User Guide

The following information is needed when connecting the application server to the database server.

Database must be one of the following:

• MySQL 8 (recommended) — Install and configure MySQL
• Microsoft SQL Server 2019 & 2022 — Install and configure Microsoft SQL Server

The application server must be allowed to communicate remotely with the database server over the listening ports.

Default ports are:

• MySQL = 3306
• Microsoft SQL Server = 1433

Database schema name

The database owner must be able to create one:

• A new database schema
• Tables inside an existing database schema of the given name

The database name must follow these rules:

• Start with a letter (a–z)
• Contain any number of characters: a–z, 0–9 or an underscore ("_")
• Letters must be lowercase

The database must be able to accept a minimum of 300 concurrent connections.

SAML schema username

OAuth database username

The username and password for SAML and OAuth must match what's entered in the Microsoft SQL Server upgrade preparation script. See Install and configure Microsoft SQL Server for more details.