Configuring the Audience Manager and Outbound E-mail databases for integrated authentication

If you have selected to enable integrated Windows authentication for the Audience Manager database while installing Content Manager, or if you have configured integrated authentication in your Storage Layer configuration file for Outbound E-mail, make your configuration for integrated authentication complete by granting permissions to database users in your SQL Server database(s).

Procedure

  1. Using SQL Server client software, access a database server containing the database for which you want to set up integrated authentication.
  2. For the Audience Manager database, ensure that the user accounts of any users that need to access your database are listed under Security > Logins. You typically would have specified these accounts during installation or configuration. Ensure that they include:
    • The MTS User account
    • <DOMAIN>\<MACHINE>$, where DOMAIN and MACHINE identify the Content Manager server machine.
  3. For the Audience Manager database, also ensure that the database user or users have the following roles and permissions:
    • db_datareader
    • db_datawriter
    • ALTER permissions on the IMPORT_CONTACTS table
    • ALTER permissions on the IMPORT_KEYWORDS table
  4. For the Outbound E-mail subscription management database, ensure that the database users have the db_datareader role.
  5. For the Outbound E-mail tracking database, no changes are needed.