Skip to main content

Jama Connect User Guide

Preparing your database server (KOTS)

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

Information

Requirements

Type/vendor

Database must be one of the following:

Database hostname

Example: jama.companydb.com

Listening ports

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

Username

jamauser

Password

Connections

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

SAML schema username

samluser

OAuth database username

oauthuser

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.

In this section: