Jama Connect User Guide

Use Microsoft SQL for the database server
  1. Download and install a supported version of SQL Server.

  2. Configure SQL Server to operate in mixed mode for authentication; the option is referred to as SQL Server and Windows Authentication. Microsoft has created a document about how to change server authentication mode.

  3. Enable TCP/IP for SQL Server. you must know which port is configured because it's necessary when connecting Jama Connect to the database. The default port is 1433.

  4. Create a new login with SQL Server authentication, such as "jamauser."

  5. Create a new database named "jama." Ensure that the user created has db_owner permissions.

  6. Some processes can cause the database to lock users while they are trying to work or log into Jama Connect. Execute the following queries to unlock tables permanently:

    1. Run the following query (as a user with db_owner role for the database). It rolls back any other transaction immediately.

      ALTER DATABASE jama SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE;
    2. Check to make sure the flag was successfully turned on. If the returned value is 1, it's on.

      SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name='jama';

Note

Steps 5 and 6 are optional, as long as the user has sufficient access to create a schema within the database. This can be done when configuring Replicated settings.