Test-MgmtSvcSqlHostingServer

Test-MgmtSvcSqlHostingServer

Verifies a SQL hosting server.

Syntax

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

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


 

Detailed Description

The Test-MgmtSvcSqlHostingServer cmdlet verifies 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

 

-Name<String>

Specifies the name of a SQL server.

 

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

 

<CommonParameters>

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

Examples

Example 1: Verify 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 tests the SQL hosting server named SQLServer01.Contoso.com, using the credentials provided in the first command.

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

 

Related topics

Add-MgmtSvcSqlHostingServer

Get-MgmtSvcSqlHostingServer

Set-MgmtSvcSqlHostingServer

Remove-MgmtSvcSqlHostingServer