Share via

SQL Server Master Instance Configuration Properties - Pre CU9 Release

Applies to: SQL Server 2019 (15.x)

Important

The Microsoft SQL Server 2019 Big Data Clusters is retired. Support for SQL Server 2019 Big Data Clusters ended as of February 28, 2025. For more information, see the announcement blog post and Big data options on the Microsoft SQL Server platform.

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.

Properties

You can configure the following SQL Server options for the master instance at deployment time.

Property Options
[sqlagent] enabled = { true | false }
[telemetry] customerfeedback = { true | false }
[telemetry] userRequestedLocalAuditDirectory = </path/file>
[licensing] pid = { Enterprise | Developer }
[traceflag] traceflag<#> = <####>

Examples

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 SQL Server Big Data Clusters.

Next steps

Configure master instance of SQL Server Big Data Clusters