Adding the User Context in SQL Server - Brainware Intelligent Capture - Foundation 23.1 - Foundation 23.1 - Brainware - external

Brainware API Installation

Platform
Brainware
Product
Brainware Intelligent Capture
Release
Foundation 23.1
License

To use the Brainware API (BAPI), your users need access rights for the SQL Server database with the BAPI user context. The default user context is Network Service. You can change the default user context to a service account.

Note: If you log on to SQL Server using Windows authentication, you need to add the domain username to the SQL Server database in addition to the NT Authority/Network Service.

To add the user context to SQL Server, complete the following steps.

  1. In Microsoft SQL Server Management Studio, in the left pane, click Security > Logins.
  2. Right-click Logins and then click New Login.
  3. In the Login dialog box, click Search.
  4. In the Select User or Group dialog box, in the Enter the object name to select field, type either IIS AppPool\BrainwareAPIAppPool or the name of the user context, click Check Names and then click OK.
  5. In the Login Properties dialog box, in the left pane, click User Mapping.
  6. In the upper right pane, in the Map column, select the check box for the required database.
  7. In the lower right pane, select the following database roles and then click OK.
    • db_datareader
    • db_datawriter
    • db_runner