Skip to main content
Skip table of contents

Using an Azure SQL Managed Instance Database with IGEL UMS

This article describes how to connect an Azure SQL Managed Instance database to the IGEL Universal Management Suite (UMS).

For details on the supported database systems, see the "Supported Environment" section of the release notes. Details of the requirements when installing and operating the database can be found in the documentation for the particular DBMS.


Creating Your Azure SQL Managed Instance

→ Follow the steps described in the document Getting started with Azure SQL Managed Instance.

Connecting Your Azure SQL Managed Instance Database to Your UMS

→  In the UMS Administrator > Data Source, create a new data source with the following parameters:

  • DB type: Microsoft SQL Server

  • Host: The hostname or IP address of the Managed Instance 

  • Port: The port on which the Managed Instance listens for requests. (Default: 1433)

  • User: The login name for connecting to the database

  • Database / SID: The database name

  • Schema: The database schema

  • JDBC Parameter (double-click): 

    • sendStringParametersAsUnicode: false

    • trustServerCertificate: true

Configuring Entra ID Authentication

→ Follow the steps described in the document https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql .

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.