1. Server Manager Guide
  2. Configuring the jde.ini Settings for the Enterprise Server and HTML Server

Configuring the jde.ini Settings for the Enterprise Server and HTML Server

To enable read-only routing in availability group for Microsoft SQL Server database, update the jde.ini settings using the following steps:

  1. For Enterprise Server, use this navigation:

    Enterprise Server > Configuration > Database > Configuration > View: Advanced > Bootstrap Datasource

  2. Select ReadOnly for ODBC Application Intent.

  3. For HTML Server, use this navigation:

    HTML Server > Configuration > Database > Configuration > View: Advanced > JDBj Runtime Properties

  4. Select ReadOnly for MS SQL Application Intent.

Important: ReadWrite option is also available for the Application Intent setting. ReadWrite allows a secondary replica to redirect read-write connection requests. See Microsoft documentation, Read/write connection redirection.