Modifying the Database Connection String - Brainware Intelligent Capture - Foundation 23.1 - Foundation 23.1 - Brainware - external - Brainware/Brainware-Intelligent-Capture/Foundation-23.1/Brainware-API-Installation/About-Brainware-API-Installation/Modifying-the-Database-Connection-String - 2023-11-08 - To modify the database connection string, complete the following steps.

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.