Mssql Connection Properties

host (string, required)

The hostname or ip address of the MSSQL server

Example: "example.org"

port (integer)

The port of the MSSQL server

Default: 1433

Example: 1433

username (string, required)

The username to connect to the MSSQL server

password (string, required)

The password to connect to the MSSQL server

domain (string)

The domain to use

database (string, required)

The database to use

protocol (string, enum)

Specifies the TDS (Tabular Data Stream) protocol version for the MSSQL server connection. TDS is a protocol that is used to transfer data between clients and MSSQL servers. Set this to one of the following values. Make sure to select a TDS version that is compatible with your MSSQL instance to ensure proper functionality.

This element must be one of the following enum values:

• 7_1

• 7_2

• 7_3_A

• 7_3_B

• 7_4

Default: "7_4"

useEncryption (boolean)

Use encryption for the connection to the MSSQL server

Default: true

assumeUTC (boolean)

Assume UTC values for the connection

Default: true

connectTimeout (integer)

The number of milliseconds before the attempt to connect is considered failed

Default: 15000

requestTimeout (integer)

The number of milliseconds before a request is considered failed, or 0 for no timeout

Default: 15000

cancelTimeout (integer)

The number of milliseconds before the cancel (abort) of a request is considered failed

Default: 5000

maxPoolSize (integer)

The maximum number of connection mantained in the connection pool

Default: 5

connectionStrategy (object)

If a connection attempt fails, retries will be performed with increasing delay (waiting time) in between. The following parameters control how these delays behave.

Properties of the connectionStrategy object:

initialDelay (integer)

Delay (waiting time) of the first connection retry (in milliseconds). For subsequent retries, the delay will be increased according to the parameter incrementFactor which has a default value of 2.

Default: 1000

Additional restrictions:

• Minimum: 1000

maxDelay (integer)

Maximum delay (waiting time) to wait until the next retry (in milliseconds). The delay (waiting time) for any subsequent connection retry will not be larger than this value. Must be strictly greater than initialDelay.

Default: 30000

incrementFactor (integer)

The factor used to increment initialDelay up to maxDelay. For example if initialDelay is set to 1000 and maxDelay to 5000 the values for the delay would be 1000, 2000, 4000, 5000.

Default: 2

Additional restrictions:

• Minimum: 2