# 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)

The protocol version to use for the connection to the MSSQL server

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`