Home / Commands / New-sqmSqlCertificate
New-sqmSqlCertificate
TLS sqmSQLTool v1.8.2+
Creates a new self-signed SQL Server certificate as a renewal of an existing one.

Examples

# Simple renewal without automatic binding
# Simple renewal without automatic binding
    New-sqmSqlCertificate -SqlInstance "SQL01" -CertificateName "AG_CERT" -BackupEncryptionPassword (Read-Host -AsSecureString)
# With automatic endpoint binding and 10-year validity
# With automatic endpoint binding and 10-year validity
    New-sqmSqlCertificate -SqlInstance "SQL01" -CertificateName "AG_CERT" `
        -ValidityYears 10 -BindEndpoint `
        -BackupEncryptionPassword (Read-Host -AsSecureString "Backup-Passwort")
# Renew TDE certificate
# Renew TDE certificate
    New-sqmSqlCertificate -SqlInstance "SQL01" -CertificateName "TDE_PROD" `
        -BindTde -BackupEncryptionPassword (Read-Host -AsSecureString "Backup-Passwort")
← Previous Command
New-sqmCertificateRequest
Next Command →
Set-sqmSqlTlsCertificate