Add-AzSqlServerTransparentDataEncryptionCertificate
為指定的 SQL Server 實例新增 透明資料加密 憑證
Syntax
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>]
Description
Add-AzSqlManagedInstanceTransparentDataEncryptionCertificate 會為指定的 SQL Server 實例新增 透明資料加密 憑證
範例
範例 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
使用資源組名和 SQL Server 名稱將 TDE 憑證新增至 SQL Server
範例 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
使用伺服器 resourceId 將 TDE 憑證新增至伺服器
範例 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
將 TDE 憑證新增至資源群組中的所有 SQL Server
參數
-Confirm
執行 Cmdlet 之前先提示您確認。
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
用於與 Azure 通訊的認證、帳戶、租用戶和訂用帳戶。
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-PassThru
在 [成功執行] 上,傳回已新增的憑證物件。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Password
透明資料加密 憑證的密碼
Type: | SecureString |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-PrivateBlob
透明資料加密 憑證的私人 Blob
Type: | SecureString |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
資源組名
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServerName
伺服器名稱
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SqlServer
sql server 輸入物件
Type: | AzureSqlServerModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-SqlServerResourceId
sql server 資源標識符
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-WhatIf
顯示執行 Cmdlet 後會發生的情況。 未執行 Cmdlet。
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
輸入
輸出
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應