Setting a Fail-Over Connection String
  • 08 Aug 2024
  • 1 Minute to read
  • Dark
    Light

Setting a Fail-Over Connection String

  • Dark
    Light

Article summary

When SQL Server replication is configured, Decisions will automatically route to a Secondary Database in the event of failure in the Primary Database. Otherwise, when data is added to the Primary Database, it copies that data to another database that is not on the same server.

Such secondary connections can be established after installation via the Decisions Installer's Settings.  


Restore To Primary Database
If the server trips the secondary connection, this would create a UsingFailoverConnection.txt file. In order to restore the connection to the primary database, this file must be deleted at C:\Program Files\Decisions\Decisions Server\Instances\Control\Database\UsingFailoverConnection.txt

Example

  1. Download and open DecisionsServerInstaller.exe from Decisions Releases
  2. From the Decisions Installer, click EDIT SETTINGS.

  3. From the Settings window, locate SecondDatabaseConnectString

  4. Provide the desired ConnectString, this can lead to an alternate database on the same server, ie., changing the Initial Catalog value to match a database that exists in MSSQL called "decisionsalt", or it may be the same as the value found in DatabaseConnectString.

    Then, click Save and close the installer.



For further information on Administration, visit the Decisions Forum.

Was this article helpful?