Documentation Center

Configuring the Add-ons database for integrated authentication for Content Manager

While installing or configuring the Add-ons feature, you may have set up integrated authentication to the SQL Server database. If so, you can now configure the database server itself to complete the configuration of integrated authentication for Content Manager.

Procedure

  1. Using SQL Server client software, access a database server containing the Add-ons database.
  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 server on which you installed the Add-ons Service, 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:
    • SELECT permissions on the __EFMigrationHistory table
    • SELECT permissions on the ADDONSERVICE_DB_INFO table
    • DELETE, INSERT, SELECT and UPDATE permissions on all the other tables of the Add-ons database.
  5. 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 DOMAIN\MACHINE$.
  6. Close your SQL Server client software.
  7. Go to the bin\ subfolder of the root folder where the Add-ons Service service is installed.
  8. Open appsettings.json for editing.
  9. Find the ConnectionString property, which is set to a list of property-value pairs. Remove the property-value pairs for User Id and Password, and replace them with the property-value pair Integrated Security=true.
  10. Save and close appsettings.json.
  11. Restart the Add-ons Service.