Add-AzSqlServerTransparentDataEncryptionCertificate

Referensi

Modul:: Az.Sql

Menambahkan Sertifikat Enkripsi Data Transparan untuk instans SQL Server yang diberikan

Sintaks

Add-AzSqlServerTransparentDataEncryptionCertificate
   [-PassThru]
   [-ResourceGroupName] <String>
   [-ServerName] <String>
   [-PrivateBlob] <SecureString>
   [-Password] <SecureString>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Add-AzSqlServerTransparentDataEncryptionCertificate
   [-PassThru]
   [-SqlServer] <AzureSqlServerModel>
   [-PrivateBlob] <SecureString>
   [-Password] <SecureString>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Add-AzSqlServerTransparentDataEncryptionCertificate
   [-PassThru]
   [-SqlServerResourceId] <String>
   [-PrivateBlob] <SecureString>
   [-Password] <SecureString>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Deskripsi

Add-AzSqlManagedInstanceTransparentDataEncryptionCertificate menambahkan Sertifikat Enkripsi Data Transparan untuk instans SQL Server yang diberikan

Contoh

Contoh 1

$privateBlob = "MIIJ+QIBAzCCCbUGCSqGSIb3DQEHAaCCCaYEggmiMIIJnjCCBhcGCSqGSIb3Dasdsadasd"
$securePrivateBlob = $privateBlob  | ConvertTo-SecureString -AsPlainText -Force
$password = "CertificatePassword"
$securePassword = $password | ConvertTo-SecureString -AsPlainText -Force
Add-AzSqlServerTransparentDataEncryptionCertificate -ResourceGroupName "YourResourceGroupName" -ServerName "YourServerName" -PrivateBlob $securePrivateBlob -Password $securePassword

Menambahkan sertifikat TDE ke server sql menggunakan nama grup sumber daya dan nama SQL Server

Contoh 2

$privateBlob = "MIIJ+QIBAzCCCbUGCSqGSIb3DQEHAaCCCaYEggmiMIIJnjCCBhcGCSqGSIb3Dasdsadasd"
$securePrivateBlob = $privateBlob  | ConvertTo-SecureString -AsPlainText -Force
$password = "CertificatePassword"
$securePassword = $password | ConvertTo-SecureString -AsPlainText -Force
$server = Get-AzSqlServer -ServerName "YourServerName" -ResourceGroupName "YourResourceGroupName" 
Add-AzSqlServerTransparentDataEncryptionCertificate -SqlServerResourceId $server.ResourceId -PrivateBlob $securePrivateBlob -Password $securePassword

Menambahkan sertifikat TDE ke server menggunakan resourceId server

Contoh 3

$privateBlob = "MIIJ+QIBAzCCCbUGCSqGSIb3DQEHAaCCCaYEggmiMIIJnjCCBhcGCSqGSIb3Dasdsadasd"
$securePrivateBlob = $privateBlob  | ConvertTo-SecureString -AsPlainText -Force
$password = "CertificatePassword"
$securePassword = $password | ConvertTo-SecureString -AsPlainText -Force
Get-AzSqlServer | Add-AzSqlServerTransparentDataEncryptionCertificate -ResourceGroupName "YourResourceGroupName" -PrivateBlob $securePrivateBlob -Password $securePassword

Menambahkan sertifikat TDE ke semua server sql dalam grup sumber daya

Parameter

-Confirm

Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.

Type:	IAzureContextContainer
Aliases:	AzContext, AzureRmContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-PassThru

Pada eksekusi Berhasil, mengembalikan objek sertifikat yang ditambahkan.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Password

Kata Sandi untuk Sertifikat Enkripsi Data Transparan

Type:	SecureString
Position:	2
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-PrivateBlob

Blob Privat untuk Sertifikat Enkripsi Data Transparan

Type:	SecureString
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ResourceGroupName

Nama Grup Sumber Daya

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ServerName

Nama Server

Type:	String
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlServer

Objek input server sql

Type:	AzureSqlServerModel
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-SqlServerResourceId

Id sumber daya server sql

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-WhatIf

Menunjukkan apa yang akan terjadi jika cmdlet berjalan. Cmdlet tidak dijalankan.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Input

AzureSqlServerModel

String

Output

Boolean