We recommend adding groups / users to your Azure database using the Harmony Database Manager:
Launch the Harmony Database Manager.
The Harmony Database Manager utility opens.
Click the Add Users and Groups tab.
In the Connect to Database section, type the credentials you want to use to connect to the database. This account must have access to the database and have permission to add users to the database.
In order to add Azure Active Directory (AD) users, you must be connected via one of the Azure AD Authentication methods, preferably with the Azure AD administrator account.
In the Add Users or Groups section, specify the authentication type for the group(s) or user(s) to be added. Note that for Azure SQL, the Harmony Database Manager only adds Contained Users to the database — meaning there are no associated logins created on the server. This is different from a non-Azure SQL database, which adds both a login and a user. If a user already exists, the utility skips creating a new user and attempts to add the user to the required database roles.
a. If you want to add Azure AD users, select Windows Authentication.
b. If you want to add SQL users, Select SQL Server Authentication.
Specify the Username / Group. An example of an Azure AD domain name is: FirstName.LastName@myazuredomain.com.
Click Add Users.
A contained user is created on the database and is given the proper roles to access the database through Harmony Enterprise.