Set-sqmSqlTlsCertificate
TLS sqmSQLTool v1.8.2+
Binds a Windows certificate from the Machine store to SQL Server as the TLS certificate.

Examples

Set-sqmSqlTlsCertificate -SqlInstance "SQL01" -Thumbprint "A1B2C3D4E5F6..."
Set-sqmSqlTlsCertificate -SqlInstance "SQL01" -Thumbprint "A1B2C3D4E5F6..."

    Binds the specified certificate to the default instance on SQL01.
    Service restart must be performed manually.
Set-sqmSqlTlsCertificate -SqlInstance "SQL01\INST1" -Thumbprint "A1B2C3D4E5F6..." -ForceEncryption -Restart
Set-sqmSqlTlsCertificate -SqlInstance "SQL01\INST1" -Thumbprint "A1B2C3D4E5F6..." -ForceEncryption -Restart

    Binds the certificate to the named instance INST1, enables Force Encryption,
    and restarts the SQL Server service automatically.
Set-sqmSqlTlsCertificate -Thumbprint "A1 B2 C3 D4 E5 F6" -WhatIf
Set-sqmSqlTlsCertificate -Thumbprint "A1 B2 C3 D4 E5 F6" -WhatIf

    Shows what would be done for the local default instance without making changes.
    Thumbprint spaces are stripped automatically.