LAST UPDATED: 28 January 2024

Configuring SQL Server for the 27k1 RMS application

SQL Server 2022 16.x and above is compatible with the 27k1 RMS application. Microsoft Entra being unavailable on earlier versions.

The following link demonstrates how to use MFA with SQL Server.

Using multifactor Microsoft Entra authentication - Azure SQL Database & SQL Managed Instance & Azure Synapse Analytics | Microsoft Learn

Download and install SQl Server Management Studio

To setup an SQL Database user account download SQL Server Management Studio from the following link

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

If SSMS can access the database then the 27k1 RMS should also be able to access the database,