Add-AzSqlServerTransparentDataEncryptionCertificate
Agrega un certificado Cifrado de datos transparente para la instancia de SQL Server determinada.
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 agrega un certificado de Cifrado de datos transparente para la instancia de SQL Server determinada.
Ejemplos
Ejemplo 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
Agregar un certificado TDE a un servidor sql server mediante el nombre del grupo de recursos y el nombre de SQL Server
Ejemplo 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
Adición de un certificado TDE a los servidores mediante el resourceId de servidor
Ejemplo 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
Agregar certificado TDE a todos los servidores SQL Server de un grupo de recursos
Parámetros
-Confirm
Le solicita su confirmación antes de ejecutar el cmdlet.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
Credenciales, cuenta, inquilino y suscripción usados para la comunicación con Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-PassThru
En Ejecución correcta, devuelve el objeto de certificado que se agregó.
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Password
Contraseña del certificado de Cifrado de datos transparente
Type: | SecureString |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-PrivateBlob
Blob privado para certificado de Cifrado de datos transparente
Type: | SecureString |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
Nombre del grupo de recursos
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServerName
Nombre del servidor
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SqlServer
Objeto de entrada de sql Server
Type: | AzureSqlServerModel |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-SqlServerResourceId
Identificador de recurso de sql Server
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-WhatIf
Muestra lo que sucedería si se ejecutara el cmdlet. El cmdlet no se ejecuta.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Entradas
Salidas
Comentarios
https://aka.ms/ContentUserFeedback.
Próximamente: A lo largo de 2024 iremos eliminando gradualmente GitHub Issues como mecanismo de comentarios sobre el contenido y lo sustituiremos por un nuevo sistema de comentarios. Para más información, vea:Enviar y ver comentarios de