Table of Contents

Database server connection strings

In Tenant Management, the Database server screen always exposes connection settings through tabs. When the current connection string can be represented structurally, the screen opens on Main and you can move between the structured tabs and the full connection string on Advanced.

If the current connection string is valid but cannot be represented by the structured editor, Tenant Management shows an informational callout and keeps the screen on Advanced.

If the current connection string is invalid, Tenant Management shows an error callout and keeps the screen on Advanced until the full connection string is corrected.

Tabs

The editor exposes these groups of settings:

  • Main: Host / server, Port, Database target, User, Password.
  • Pooling: Enable pooling, Min pool size, Max pool size, Connection timeout.
  • Security:
    • Oracle: Connection lifetime, Validate connection.
    • PostgreSQL: SSL mode, Trust server certificate.
    • SQL Server: Encrypt, Trust server certificate.
  • Advanced: the full provider connection string.

Provider support and fallback

  • PostgreSQL: structured editing is available when the connection string can be parsed by the provider.
  • SQL Server: structured editing is available for SQL authentication connection strings. Integrated security is not supported in the structured editor. If the server value cannot be represented as a host and optional numeric port, use the raw field.
  • Oracle: structured editing is available for EZConnect data sources such as host/service or host:port/service. TNS descriptors, aliases, and other non-EZConnect formats stay in the raw field.

If the current connection string is valid but incompatible with the structured editor, Tenant Management displays an informational message, keeps Advanced selected, and prevents switching to Main, Pooling, or Security. If the current connection string is invalid, Tenant Management displays an error instead. In both cases, rewrite the full connection string into a supported format to re-enable the structured tabs.

Full connection string and pooling

Use the Advanced tab when you need the raw provider syntax, including provider-specific properties that are not surfaced as dedicated structured fields.

The Advanced tab always stays reachable. When the structured settings cannot be turned into a connection string, Tenant Management shows the reason in an error callout, fills the full connection string field with a best-effort preview, and still opens the tab so that you can repair the string by hand.

For pooling, make sure that Min pool size is less than or equal to Max pool size. An inconsistent pair is reported as soon as you type it, and it blocks saving, but it never prevents you from opening Advanced.

For the raw provider syntax, see SQL Server database, Oracle database, and PostgreSQL database.