Documentation Center

Configuring the Topology Manager database for integrated authentication

If you have set up integrated authentication to the Topology Manager SQL Server database while installing or configuring Topology 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>$, as well as the user who was logged in when you installed the Content Manager server, have the following permission:
    • SELECT permission on the TTM_DB_INFO table.
  5. Ensure that the user accounts of any users that need to access your database are listed under Security > Logins. You would typically have specified these user accounts during installation or configuration. Ensure that they include:
    • <DOMAIN>\<MACHINE>$
    • The user who was logged in when you ran the Content Manager installer.