Modifying the Database Connection Strings - Brainware Intelligent Capture - Foundation 23.1 - Foundation 23.1 - Brainware - external

To modify the database connection strings for all BIC components, except Web Verifier, complete the following steps.

1. From the [Installation path]\Brainware Intelligent Capture\bin directory, open DstDsr.exe.config in a text editor.
2. Search for the <connectionStrings> element.
   Note: For information about password encryption, see Encrypt the password for a database connection string.
3. For a SQL Server database, modify the following values.
   • Set Data Source.
   • Set Initial Catalog to the SQL Server database catalog.
   • Set User ID to the SQL Server user ID.
   • Set Password to the SQL Server password.

   <connectionStrings>
     <add name="Entities" connectionString="metadata=res://*/Entity.Entities.csdl|res://*/Entity.Entities.ssdl|r es://*/Entity.Entities.msl; provider=System.Data.SqlClient;provider connection string=&quot;Data Source=<DataSource>;Initial Catalog=<SQLServerDatabaseCatalog>;Integrated Security=false;User ID=<UserId>;Password=<UserPassword>;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" /> 
   </connectionStrings>

   Note: To copy the connections string example as a single line, open this document in Acrobat Reader and copy and paste the string from there.
4. For an ORACLE database, modify the following values.
   • Set Data Source.
   • Set User ID to the service account user ID.
   • Set Password to the service account password.

   <connectionStrings>
      <add name="Entities" connectionString="metadata=res://*/Entity.ORAEntities.csdl|res://*/Entity.ORAEntities. ssdl|res://*/Entity.ORAEntities.msl; provider=EFOracleProvider; Provider Connection String='Data Source=<OracleServerName\InstanceName>;User ID=<UserID>;Password=<UserPassword>'" providerName="System.Data.EntityClient" /> 
   </connectionStrings>

   Note: To copy the connections string example as a single line, open this document in Acrobat Reader and copy and paste the string from there.
5. Save and close the file.
6. Repeat the previous steps for the following configuration files.
   • DstVer.exe.config
   • DstHost.exe.config
   • DstSlm.exe.config
   • DstCoreSvc.exe.config
   • Brainware.System.Project.exe.config
   • DstWkBrw.exe.config