Documentation Center

Configuring the Audience Manager database for integrated authentication

If you have selected to enable integrated Windows authentication for the Audience Manager database while installing Content Manager, 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 Subscription database, ensure that the database users have the db_datareader role.