Add-MgmtSvcSqlHostingServer

Adds a SQL hosting server to Windows Azure Pack.

Syntax

Parameter Set: ByProperties
Add-MgmtSvcSqlHostingServer [-AdminUri] <Uri> [-Token] <String> [-Name] <String> [-TotalSpaceMB] <Int32> [-User] <PSCredential> [-ServerGroupId] <String> [-DisableCertificateValidation] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameter Set: ByObject
Add-MgmtSvcSqlHostingServer [-AdminUri] <Uri> [-Token] <String> [[-HostingServer] <SqlHostingServer> ] [-ServerGroupId] <String> [-DisableCertificateValidation] [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed Description

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

Parameters

-AdminUri<Uri>

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.

Aliases	none
Required?	true
Position?	1
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-DisableCertificateValidation

Disables certificate validation for the Windows Azure Pack installation.

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

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-HostingServer<SqlHostingServer>

Specifies a SQL hosting server object.

Aliases	none
Required?	false
Position?	3
Default Value	none
Accept Pipeline Input?	True (ByValue)
Accept Wildcard Characters?	false

-Name<String>

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.

Aliases	none
Required?	true
Position?	3
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-ServerGroupId<String>

Specifies the ID for a SQL server group.

Aliases	none
Required?	true
Position?	6
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Token<String>

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

Aliases	none
Required?	true
Position?	2
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-TotalSpaceMB<Int32>

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

Aliases	none
Required?	true
Position?	4
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-User<PSCredential>

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

Aliases	none
Required?	true
Position?	5
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Confirm

Prompts you for confirmation before executing the command.

Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-WhatIf

Describes what would happen if you executed the command without actually executing the command.

Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

<CommonParameters>

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

Examples

Example 1: Add a SQL hosting server

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.

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

Add-MgmtSvcSqlHostingServer