Configuring the Content Manager database for integrated authentication

If you have set up integrated authentication to the Content Manager SQL Server database while installing or configuring Content Manager, you can complete your integrated authentication by configuring the database server itself.

Procedure

  1. Using SQL Server client software, access a database server containing the database for which you want to set up integrated authentication.
  2. Select the database and navigate to Security > Users.
  3. If you do not see a user called <DOMAIN>\<MACHINE>$, where <DOMAIN> and <MACHINE> identify the Content Manager server, add a user by that name to the database by right-clicking and selecting Users > New User from the context menu that opens.
  4. Ensure that <DOMAIN>\<MACHINE>$ has the following permissions:
    • DELETE, INSERT, SELECT and UPDATE permissions on the BINARIES table.
    • DELETE, INSERT, SELECT and UPDATE permissions on the SignalR schema.
    • SELECT permissions on the TDS_DB_INFO table.
  5. Do the same for the user who was logged in when you installed Content Manager server, and grant this user the following permissions.
    • SELECT permission on the TDS_DB_INFO table.
  6. 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 user accounts during installation or configuration. Ensure that they include:
    • The MTS User account
    • <DOMAIN>\<MACHINE>$
    • The user who was logged in when you ran the Content Manager installer.