Add-MgmtSvcSqlServerGroup

Adds a SQL Server group to Windows Azure Pack.

Syntax

Add-MgmtSvcSqlServerGroup [-AdminUri] <Uri> [-Token] <String> [-GroupName] <String> [-ResourceGovernorEnabled]
 [-Confirm] [-DisableCertificateValidation] [-WhatIf] [<CommonParameters>]
Add-MgmtSvcSqlServerGroup [-AdminUri] <Uri> [-Token] <String> [[-ServerGroup] <SqlServerGroup>] [-Confirm]
 [-DisableCertificateValidation] [-WhatIf] [<CommonParameters>]

Description

The Add-MgmtSvcSqlServerGroup cmdlet adds a SQL Server group to Windows Azure Pack for Windows Server.

Examples

Example 1: Add a SQL Server group

PS C:\> Add-MgmtSvcSqlServerGroup -AdminUri "https://Computer01:30004" -Token $Token -GroupName "SQL Group 01"
NOTE: This example assumes that you have created a token by using **Get-MgmtSvcToken** and have stored it in a variable named $Token. This example adds a SQL Server group named SQL Group 01.

Parameters

-AdminUri

Specifies the URI of the Windows Azure Pack administrator API.
Use the following format: https://< computer>:<port>, where <computer> is the computer on which the administrator API is installed.

Type:Uri
Required:True
Position:0
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

-DisableCertificateValidation

Disables certificate validation for the Windows Azure Pack installation.

If you specify this parameter, you can use self-signed certificates.

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

-GroupName

Specifies a name for the SQL Server group.

Type:String
Required:True
Position:3
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-ResourceGovernorEnabled

Indicates that the server group has the resource governor enabled.

Type:SwitchParameter
Required:False
Position:4
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-ServerGroup

Specifies a SQL Server group object.

Type:SqlServerGroup
Required:False
Position:3
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False

-Token

Specifies an identity token.
To create a token, use the Get-MgmtSvcToken cmdlet.

Type:String
Required:True
Position:1
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

SqlServerGroup

You can pipe a **SqlServerGroup** object to this cmdlet.

Outputs

SqlServerGroup

This cmdlet emits a **SqlServerGroup** object.