- 2 minutes to read

SqlPackageParams - System Parameter

Microsoft introduced a compatibility break with version 161 of DacFX. To ensure seamless operation, you must use a matching set of binaries for both Nodinite and DacFX:

DacFX Version Nodinite Install and Update Tool Nodinite
>= 161 >= 6.0.0.5 >= 5.4.1.26
< 161 < 6.0.0.5 < 5.4.1.26

The System parameter SqlPackageParams allows you to instruct the Nodinite Logging Service on how to connect to SQL Server. The Nodinite Install and Update Tool also uses this value during system updates. This flexibility ensures you can tailor connectivity and security to your organization's requirements, supporting both compliance and operational efficiency.

System Parameter Name Data Type Values/Example Comment
SqlPackageParams json JSON object as exemplified Default = {"TargetTrustServerCertificate":true,"TargetEncryptConnection":true,"SourceTrustServerCertificate":false,"SourceEncryptConnection":true}

This feature was introduced in version 5.4.1.26.

JSON Structure and Example

  • TargetTrustServerCertificate – default: true
  • TargetEncryptConnection – default: true
  • SourceTrustServerCertificate – default: false
  • SourceEncryptConnection – default: true
{"TargetTrustServerCertificate":true,"TargetEncryptConnection":true,"SourceTrustServerCertificate":false,"SourceEncryptConnection":true}

Frequently Asked Questions

Find more solutions to common problems and the Nodinite System Parameters FAQ in the Troubleshooting user guide.

Where can I get the latest DacFX?

Please download and install the latest DacFX.

How do I change the value?

Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.

Next Step

Administration