While installing or configuring Access Management, 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
- Using SQL Server client software, access a database server containing the Access Management database.
- Select the database and navigate to .
- If you do not see a user called
DOMAIN\MACHINE$, where DOMAIN and MACHINE identify the server on which you installed the Access Management service, 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:
SELECT permissions on the __EFMigrationHistory table
SELECT permissions on the ACCESSMANAGEMENT_DB_INFO table
DELETE, INSERT, SELECT and UPDATE permissions on all the other tables of the Access Management database.
- 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
DOMAIN\MACHINE$.
- Close your SQL Server client software.
- Go to the bin\ subfolder of the root folder where the Access Management service is installed.
- Open appsettings.json for editing.
- 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.
- Save and close appsettings.json.
- Restart the Access Management service.