Database Requirements for TopTeam Repository

Installation

Overview

This article explains the compatible database versions and requirements for connecting TopTeam Application Server and TopTeam Web Server with the databases listed above.

Who should read this?

  • TopTeam Administrators
  • IT Support

Supported Database

  • TopTeam application supports Microsoft SQL Server database.

Microsoft SQL Server

1. Compatible Versions

TopTeam is compatible with the following versions of SQL Server Database of any edition .i.e. Standard, Workgroup, Enterprise or Express editions:

1. Azure SQL Server Managed Instance

2. SQL Server on Azure VM

3. SQL Server 2022

4. SQL Server 2019

5. SQL Server 2017

6. SQL Server 2016

7. SQL Server 2014

8. SQL Server 2012

9. SQL Server 2008

2. Connection Requirements

TopTeam Application Server and TopTeam Web Server can connect to SQL Server and requires:

1. The computer on which TopTeam Application Server is installed should have MDAC (Microsoft Data Components) version 2.8 or higher. You can verify this by connecting to TopTeam SQL Server Database using SQL Server Management Studio from the computer on which TopTeam Application Server is being installed.

2. The computer on which TopTeam Web Server is installed should have SQL Server Native Client component installed. For more information on SQL Server Native Client, refer to the article Requirements for TopTeam Web Server for SQL Server Database.

3. When TopTeam Application Server is running as a Windows Service and is configured to connect to SQL Server using Windows Authentication, ensure that the credentials under which the TopTeam Application Server service is running have privileges to access SQL Server.

4. Ensure that SQL Server user password which is used to connect to the database in TopTeam Application Server and TopTeam Web Server, will not expire or should not have an expiry. When a user connects to TopTeam Server, a database connection gets created on TopTeam Server for that user. If SQL Server user password has expired, the TopTeam user will not be able to connect to TopTeam Servers.

3. Configuration Requirements

1. TopTeam requires that row versioning based isolation levels should be enabled.

2. The “Allow Triggers to Fire Others” (Recursive Triggers) setting should be enabled, which is an SQL Server instance level setting.

3. Default schema of the database user who is either installing or upgrading TopTeam Database should be “dbo” (Database Owner).

Revised: November 20th, 2023

Tags: