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
- Using SQL Server client software, access a database server containing the database for which you want to set up integrated authentication.
- Select the database and navigate to .
- 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 from the context menu that opens.
- Ensure that
<DOMAIN>\<MACHINE>$ has the following permissions:
DELETE, INSERT, SELECT and UPDATE permissions on the BINARIES table.
SELECT permissions on the TDS_DB_INFO table.
- 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.
- Ensure that the user accounts of any users that need to access your database are listed under . 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.
- Ensure that these new users have administrator-level access to the software. You do this by setting the value of the
privilege column to "1" for this user.