Edit

SQL Server Master Instance Configuration Properties - Pre CU9 Release

  • Article

Applies to: SQL Server 2019 (15.x)

Important

The Microsoft SQL Server 2019 Big Data Clusters add-on will be retired. Support for SQL Server 2019 Big Data Clusters will end on February 28, 2025. All existing users of SQL Server 2019 with Software Assurance will be fully supported on the platform and the software will continue to be maintained through SQL Server cumulative updates until that time. 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