Set-MgmtSvcSqlHostingServer

Updates a SQL hosting server.

Syntax

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

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

Detailed Description

The Set-MgmtSvcSqlHostingServer cmdlet updates a SQL hosting 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

-HostingServerId<String>

Specifies the ID of a SQL hosting server.

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

-Name<String>

Specifies the name of a SQL hosting server.

Aliases	none
Required?	true
Position?	3
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: Update 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 and stores the provided user name and password in the $Credential variable.

The second command updates the total space to 4096 MB for the hosting server named SQLServer01.Contoso.com.

PS C:\> $Creds = Get-Credential
PS C:\> Set-MgmtSvcSqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "SQLServer01.Contoso.com" -TotalSpaceMB 4096 -User $Creds -HostingServerId "u37k25"

Set-MgmtSvcSqlHostingServer