Get-AzureSqlDatabaseSecureConnectionPolicy

Get-AzureSqlDatabaseSecureConnectionPolicy

Gets the secure connection policy of an Azure SQL database.

Syntax

Parameter Set: Default
Get-AzureSqlDatabaseSecureConnectionPolicy [-ResourceGroupName] <System.String> [-ServerName] <System.String> [-DatabaseName] <System.String> [-Profile <Microsoft.Azure.Common.Authentication.Models.AzureProfile> ] 

Detailed Description

The Get-AzureSqlDatabaseSecureConnectionPolicy cmdlet gets the secure connection policy of an Azure SQL database. To use the cmdlet, use the ResourceGroupName, ServerName, and DatabaseName parameters to identify the database. After this cmdlet runs successfully, it returns an object describing the current secure connection policy as well as the database identifiers. Database identifiers include, but are not limited to, ResourceGroupName, ServerName, and DatabaseName.

Parameters

-DatabaseName<System.String>

Specifies the name of the database.

Aliases

none

Required?

true

Position?

3

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

-Profile<Microsoft.Azure.Common.Authentication.Models.AzureProfile>

Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ResourceGroupName<System.String>

Specifies the name of the resource group that contains the database.

Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

-ServerName<System.String>

Specifies the name of server that contains the database.

Aliases

none

Required?

true

Position?

2

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • None

Outputs

The output type is the type of the objects that the cmdlet emits.

  • Microsoft.Azure.Commands.Sql.Security.Model.DatabaseSecureConnectionPolicyModel

Notes

  • This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see about_CommonParameters.

Examples

Example 1: Get the secure connection policy of an Azure SQL database

This command gets the secure connection policy of an Azure SQL database named Database07 located in server Server04.

PS C:\> Get-AzureSqlDatabaseSecureConnectionPolicy -ResourceGroupName "ResourceGroup11" -ServerName "Server04" -DatabaseName "Database07"

Azure SQL Database