Add-MgmtSvcSqlHostingServer

Adds a SQL Server hosting server to Windows Azure Pack.

Syntax

Add-MgmtSvcSqlHostingServer
   [-TotalSpaceMB] <Int32>
   [-SqlUser] <PSCredential>
   [-ServerGroupId] <String>
   [-Name] <String>
   [-NumberOfCpuCores <Int32>]
   [-TotalMemoryGB <Int32>]
   [-SupportedIopsPerVolume <Int32>]
   [-MaximumResourcePools <Int32>]
   [-AdminUri] <Uri>
   [-Token] <String>
   [-DisableCertificateValidation]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Add-MgmtSvcSqlHostingServer
   [-ServerGroupId] <String>
   [[-HostingServer] <SqlHostingServer>]
   [-AdminUri] <Uri>
   [-Token] <String>
   [-DisableCertificateValidation]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

The Add-MgmtSvcSqlHostingServer adds a SQL Server hosting server to Windows Azure Pack for Windows Server.

Examples

Example 1: Add a SQL hosting server

PS C:\> $Creds = Get-Credential
PS C:\> Add-MgmtSvcSqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "SQLServer01.Contoso.com" -TotalSpaceMB 2048 -ServerGroupId "g5sho0" -User $Creds

NOTE: This example assumes that you have created a token by using Get-MgmtSvcToken and have stored it in a variable named $Token.

The first command prompts the user for credentials which are stored in the $Creds variable.

The second command uses the credentials provided in the first command to add the SQL Server named SQLServer01.Contoso.com to the SQL Server group with the ID of g5sho0.

Required 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
Position:0
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-Name

Specifies the name of a SQL Server.

If you want your application databases to be publically accessible, ensure that you use a publically-accessible IP address or FQDN.

Type:String
Position:2
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-ServerGroupId

Specifies the ID for a SQL Server group.

Type:String
Position:5
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-SqlUser

Specifies a user account and password as a PSCredential object. To create a PSCredential object, use the Get-Credential cmdlet.

Type:PSCredential
Position:4
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-Token

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

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

Specifies the size, in megabytes (MB) of the hosting server.

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

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
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
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-HostingServer

Specifies a SQL Server hosting server object.

Type:SqlHostingServer
Position:2
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-MaximumResourcePools

Specifies the number of resource pools for the server.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-NumberOfCpuCores

Specifies the number of CPU cores for the server.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-SupportedIopsPerVolume

Specifies the supported I/O operations per second (IOPS) for the server.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-TotalMemoryGB

Specifies the total amount of memory, in gigabytes, for the server.

Type:Int32
Position:Named
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
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

SqlHostingServer

You can pipe a SqlHostingServer object to this cmdlet.

Outputs

SqlHostingServer

This cmdlet emits a SqlHostingServer object.