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 : True
Example 2: Enable server Advanced Data Security from server resource
Get-AzSqlServer `
-ResourceGroupName "ResourceGroup01" `
-ServerName "Server01" `
| Enable-AzSqlServerAdvancedDataSecurity
ResourceGroupName : ResourceGroup01
ServerName : Server01
IsEnabled : True
Example 3
Enables Advanced Data Security on a server. (autogenerated)
Enable-AzSqlServerAdvancedDataSecurity -DoNotConfigureVulnerabilityAssessment -ResourceGroupName MyResourceGroup -ServerName s1
Parameters
-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 |
Inputs
Outputs
Azure PowerShell