Step 3. Specify General Settings

At the Account step of the wizard, choose whether the account will be used to connect to SMTP servers or Azure databases, and specify credentials of a user account that will be used to authenticate against the servers or databases.

Important

If you select the Database account option, consider the following:

  • The specified credentials must belong to a user account that has either of the following roles assigned:
  • [Applies to SQL Server user accounts] ##MS_DatabaseManager##, ##MS_LoginManager##, ##MS_DatabaseConnector## and ##MS_DefinitionReader##. For more information on server-level roles, see Microsoft Docs.
  • [Applies to Cosmos DB for PostgreSQL user accounts] Any role that has administrative permissions; it is recommended that you use an account that has the built-in citus role assigned. For more information on native PostgreSQL roles, see Microsoft Docs.
  • Microsoft Entra ID authentication is not supported.

 

Specifying Credentials