Modifying the Database Connection String - 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 modify the database connection string, complete the following steps.

  1. From the [Installation path]\BrainwareApiServer directory, open Web.config in a text editor.
  2. Search for the <connectionStrings> element.
  3. For a SQL Server database, to connect using Windows integrated security, modify the following values.
    • Set Data Source to the required data source.
    • Set Initial Catalog to the SQL Server database catalog.
    • Remove User ID=<UserID>;Password=<UserPassword>;.
    • Set Integrated Security to SSPI.
  4. For a SQL Server database, to connect using SQL Server authentication, modify the following values.
    • Set Data Source to the data source.
    • Set Initial Catalog to the SQL Server database catalog.
    • Set User ID to the service account user ID.
    • Set Password to the service account password.
  5. For an ORACLE database, modify the following values.
    • Set Data Source to the data source.
    • Set User ID to the service account user ID.
    • Set Password to the service account password.
  6. Optional. Encrypt the password.
  7. Save and close the file.