Enable-AzSqlServerAdvancedDataSecurity
Enables Advanced Data Security on a server.
Syntax
Enable-AzSqlServerAdvancedDataSecurity
[-DoNotConfigureVulnerabilityAssessment]
[-AsJob]
[-DeploymentName <String>]
[-InputObject <AzureSqlServerModel>]
-ServerName <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
The Enable-AzSqlServerAdvancedDataSecurity cmdlet enables Advanced Data Security on a server. Advanced Data Security is a unified security package that includes Data Classification, Vulnerability Assessment and Advanced Threat Protection for your server. (A new storage account will automatically be created for saving vulnerability assessments. If a storage account was previously created for this purpose, it will be used instead)
Examples
Example 1: Enable server Advanced Data Security
Enable-AzSqlServerAdvancedDataSecurity `
-ResourceGroupName "ResourceGroup01" `
-ServerName "Server01"
ResourceGroupName : ResourceGroup01
ServerName : Server01
IsEnabled : TrueExample 2: Enable server Advanced Data Security from server resource
Get-AzSqlServer `
-ResourceGroupName "ResourceGroup01" `
-ServerName "Server01" `
| Enable-AzSqlServerAdvancedDataSecurity
ResourceGroupName : ResourceGroup01
ServerName : Server01
IsEnabled : TrueExample 3
Enables Advanced Data Security on a server. (autogenerated)
Enable-AzSqlServerAdvancedDataSecurity -DoNotConfigureVulnerabilityAssessment -ResourceGroupName MyResourceGroup -ServerName s1Parameters
-AsJob
Run cmdlet in the background
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Confirm
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DeploymentName
Supply a custom name for Advanced Data Security deployment
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DoNotConfigureVulnerabilityAssessment
Do not auto enable Vulnerability Assessment (This will not create a storage account)
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InputObject
The server object to use with Advanced Data Security policy operation
| Type: | AzureSqlServerModel |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ResourceGroupName
The name of the resource group.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ServerName
SQL Database server name.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |