Installing & Configuring TopTeam Requirements on Azure SQL Managed Instance

Overview

TopTeam Requirements is compatible with Azure SQL Managed Instance. However, specific steps must be followed to properly install the TopTeam Database Schema and configure the environment. Post-installation settings are also required to ensure full compatibility and optimal performance.

Version Information: This compatibility is supported from TopTeam Requirements version 23.03.

Installing the TopTeam Database Schema on Azure SQL Managed Instance

Step 1. Create a Database

Use the Azure portal or SQL Server Management Studio (SSMS) to create a new database in your Azure SQL Managed Instance.

Step 2. Run the TopTeam Database Schema Installer

Choose the option: In an existing database
Select the database created in Step 1 and proceed with the installation wizard.

Enabling READ_COMMITTED_SNAPSHOT

TopTeam requires the READ_COMMITTED_SNAPSHOT database option to be enabled. This can be done using SQL Server Management Studio (SSMS).

Steps to Enable READ_COMMITTED_SNAPSHOT

Open SSMS and connect to your Azure SQL Managed Instance.
In Object Explorer, expand the Databases node.
Right-click on the TopTeam Database and select Properties.
In the Database Properties window:
1. Navigate to the Options page.
2. Locate the option Is Read Committed Snapshot On.
Set this option to True.
Click OK to save the changes.

TLS Configuration Requirements for Azure SQL Managed Instance

To ensure secure and reliable connectivity to Azure SQL Managed Instance, your system must be configured with the appropriate TLS (Transport Layer Security) settings. Azure enforces strict requirements, including the use of supported TLS protocol versions and compatible cipher suites.

Please review and apply the latest Microsoft guidelines to ensure TLS compliance:

Enable only supported TLS versions (e.g., TLS 1.2 or higher).
Disable deprecated protocols, such as TLS 1.0 and TLS 1.1.
Configure only compatible cipher suites for secure client-server communication.

For the latest configuration requirements, refer to Microsoft’s official TLS documentation for Azure SQL.

Migrating a Local TopTeam Database Schema to Azure SQL Managed Instance Using Data Tier Application

Revised: April 22^nd, 2025