Edit

Share via

New-AzWorkloadsProviderSqlServerInstanceObject

Module:
Az.Workloads Module

Create an in-memory object for MsSqlServerProviderInstanceProperties.

Syntax

Default (Default) 

New-AzWorkloadsProviderSqlServerInstanceObject
    [-Password <String>]
    [-PasswordUri <String>]
    [-Port <String>]
    [-Username <String>]
    [-Hostname <String>]
    [-SapSid <String>]
    [-SslCertificateUri <String>]
    [-SslPreference <SslPreference>]
    [<CommonParameters>]

Description

Create an in-memory object for MsSqlServerProviderInstanceProperties.

Examples

Example 1: Create Microsoft SQL server provider

New-AzWorkloadsProviderSqlServerInstanceObject -Password $password -Port 1433 -Username ams -Hostname 10.1.14.5 -SapSid X00 -SslPreference Disabled

ProviderType DbPassword   DbPasswordUri DbPort DbUsername Hostname  SapSid SslCertificateUri SslPreference
------------ ----------   ------------- ------ ---------- --------  ------ ----------------- -------------
MsSqlServer  $password                  1433   ams        10.1.14.5 X00                      Disabled

Create Microsoft SQL server provider for an AMS instance

Parameters

-Hostname

Gets or sets the SQL server host name.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Password

Gets or sets the database password.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-PasswordUri

Gets or sets the key vault URI to secret with the database password.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Port

Gets or sets the database sql port.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-SapSid

Gets or sets the SAP System Identifier.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-SslCertificateUri

Gets or sets the blob URI to SSL certificate for the SQL Database.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-SslPreference

Gets or sets certificate preference if secure communication is enabled.

Parameter properties

Type:SslPreference
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Username

Gets or sets the database user name.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

CommonParameters

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

Outputs

MSSqlServerProviderInstanceProperties