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 the following roles assigned:
  • [Applies to SQL Server user accounts] The ##MS_DatabaseManager##, ##MS_LoginManager##, ##MS_DatabaseConnector## and ##MS_DefinitionReader## server-level roles, and the db_owner database-level role. For more information on server-level roles and database-level roles, see Microsoft Docs.
    Consider that the db_owner database-level role is required for backup operations only.
  • [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

Page updated 9/24/2024

Page content applies to build 7.1.0.22