| title | SQL Server master instance configuration properties |
|---|---|
| titleSuffix | SQL Server Big Data Clusters |
| description | Reference article for configuration properties for SQL Server master instance. |
| author | WilliamDAssafMSFT |
| ms.author | wiassaf |
| ms.reviewer | rahul.ajmera |
| ms.date | 02/11/2021 |
| ms.prod | sql |
| ms.technology | big-data-cluster |
| ms.topic | reference |
[!INCLUDESQL Server 2019]
[!INCLUDEbig-data-clusters-banner-retirement]
Note
The following information is only applicable to pre-CU9 release clusters that are not configuration enabled and require mssql-conf to configure the SQL Server master instance. CU9 and later release clusters take advantage of the configuration management functionality and no longer require an mssql-conf file. Available configurations for the SQL Server master instance and other SQL Server Big Data Clusters components can be found here.
You can configure the following SQL Server options for the master instance at deployment time.
| Property | Options |
|---|---|
[sqlagent] |
`enabled = { true |
[telemetry] |
`customerfeedback = { true |
[telemetry] |
userRequestedLocalAuditDirectory = </path/file> |
[licensing] |
`pid = { Enterprise |
[traceflag] |
traceflag<#> = <####> |
The following example enables SQL Agent, telemetry, sets a PID for Enterprise Edition, and enables trace flag 1204.:
[sqlagent]
enabled=true
[telemetry]
customerfeedback=true
userRequestedLocalAuditDirectory = /tmp/audit
[licensing]
pid = Enterprise
[traceflag]
traceflag0 = 1204
For instructions, see [Configure master instance of [!INCLUDEbig-data-clusters-2019]](configure-sql-server-master-instance.md).
[Configure master instance of [!INCLUDEbig-data-clusters-2019]](configure-sql-server-master-instance.md)