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

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

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\WebVerifierPool 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