Adding Database Accounts

To add a new database account, do the following:

From the main menu, navigate to Settings > Backup Settings > Azure SQL Server Accounts.
On the Azure SQL Server Accounts page, click Create.
In the Name field, enter a name for the account.

The maximum length of the account name is 32 characters. The following characters are supported: Latin letters, numeric characters, underscores and dashes. The following characters are not supported: \ / " ' [ ] : | < > + = ; , ? * @ & $.

In the Description field, enter a description of the account for future reference.
In the Username field, enter a user account that will be used to connect to SQL server.
In the Password field, enter the password for the user account that will be used to connect to SQL server.

Important

When you add a new SQL server account, consider the following:

The specified credentials must belong to a user account that has the following roles assigned: The ##MS_DatabaseManager##, ##MS_LoginManager##, ##MS_DatabaseConnector## and ##MS_DefinitionReader## server-level roles, and the db_owner database-level role. Consider that the db_owner database-level role is required for backup operations only. For more information on server-level roles and database-level roles, see Microsoft Docs.
Microsoft Entra ID authentication is not supported.