New-AzWorkloadsProviderSqlServerInstanceObject

Create an in-memory object for MsSqlServerProviderInstanceProperties.

Syntax

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.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Password

Gets or sets the database password.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-PasswordUri

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

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Port

Gets or sets the database sql port.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-SapSid

Gets or sets the SAP System Identifier.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-SslCertificateUri

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

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-SslPreference

Gets or sets certificate preference if secure communication is enabled.

Type:SslPreference
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Username

Gets or sets the database user name.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

Outputs

MSSqlServerProviderInstanceProperties