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. |
HTTPS enabled |
Yes |
If True, indicates that HTTPS is enabled. |
|
HTTPS compression enabled |
True |
Yes |
If True, indicates that HTTPS compression is enabled. For high security settings, set it to False. |
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 logging is enabled. |
TDS network name or IP override |
Yes |
Override of the server name or IP, presented by the server to SQL Client. |