Instance configuration#

This chapter describes System Instances configuration section of Querona Administrative Portal.

Configuration option

Default value

Requires restart?

Description

Name

Root

No

Friendly name of the instance visible in the top bar.

TDS port

1433

Yes

TDS port number to listen for incomming TDS connections from SQL Client.

HTTP port

80

Yes

HTTP port number to listen for incomming HTTP connections.

HTTPS port

80

Yes

HTTPs port number to listen for incomming HTTP connections.

Certificate thumbprint

Yes

Thumbprint of the server certificate used to negotiate Https and TLS connections.

Maximum TDS version

200

Yes

Maximum TDS version offered to SQL Client during application protocol negotiation.

Encryption

None

Yes

Encryption level enforced by the server.

Minimum TLS version if encryption enabled

TLS v1.2

Yes

Minimum TLS version required by the server, if encryption is enabled.

Public cluster host

localhost

Yes

Public cluster host name.

Public cluster port

26001

Yes

Public cluster port.

Max degree of parallelism

1

Yes

Max degree of parallelism.

Disable cluster communication listener

Yes

Yes

Indicates if a cluster communication listener is disabled or not.

Primary server

True

Yes

If True, indicates a primary system instance.

Connection to default federator

Local Spark

No

Connection to default federator.

Temporary files directory

%TEMPquerona

No

Path to a directory where instance keeps its temporary files.

Statement wait timeout

86400

No

Statement wait timeout

HTTP connection keep alive

True

No

If True, indicates that HTTP connections should be kept alive.

Use HTTP connection logging

False

No

If True, indicates that HTTP is enabled.

TDS network name or IP override

Yes

Override of the server name or IP, presented by the server to SQL Client.