To connect the Microsoft SQL Server, proceed as follows:

  1. Open the SQL Console of the SQL Server by selecting "New Query" in SQL Server Management Studio.
  2. Use the following script as a template, customize it (password), and then execute it.

    To avoid problems when enabling the data source, ensure that LOGIN, USER, and SCHEMA have the same name.

    CREATE DATABASE rmdb
    GO
    USE rmdb
    GO
    CREATE LOGIN igelums with PASSWORD = 'setyourpasswordhere',
    DEFAULT_DATABASE=rmdb
    GO
    CREATE USER igelums with DEFAULT_SCHEMA = igelums
    GO
    CREATE SCHEMA igelums AUTHORIZATION igelums GRANT CONTROL to igelums
    GO

  3. In the UMS Administrator, set up a new SQL Server type data source.
  4. Ensure that the port of the SQL Server in the data source is configured correctly. (Default: 1433)

The Microsoft SQL Server should allow Windows and SQL authentication.

If you deploy MS SQL Server Always On Availability Groups, use SQL Server as a DB type and specify under Host the domain name of the Always On Availability Group listener.