Set-AzureSqlDatabaseServer

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Set-AzureSqlDatabaseServer

Updates the properties of the specified Windows Azure SQL Database Server in the current subscription.

Syntax

Parameter Set: ResetServerAdminPassword
Set-AzureSqlDatabaseServer [-ServerName] <String> -AdminPassword <String> [-Force] [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed Description

The Set-AzureSqlDatabaseServer cmdlet updates the properties of the specified SQL Database Server. In the current release, you can only update the administrator account password for a SQL Database Server.

Parameters

-AdminPassword<String>

The new Administrator account password for your SQL Database Server. You must specify a strong password. For more information, see Strong Passwords (https://go.microsoft.com/fwlink/p/?LinkId=154152).

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Force

Allows the action to complete without prompting you for confirmation.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ServerName<String>

The name of the SQL Database Server to be updated. Specify only the server name, and not the fully qualified DNS name.

Aliases

none

Required?

true

Position?

1

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

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

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

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • Microsoft.WindowsAzure.Management.SqlDatabase.Model.SqlDatabaseServerContext

Outputs

The output type is the type of the objects that the cmdlet emits.

Examples

--------------Example 1--------------

This command updates the administrator account password for the SQL Database Server (“lpqd0zbr8y”) with the new password (“myNewP@ssword”).

PS C:\> Set-AzureSqlDatabaseServer -ServerName "lpqd0zbr8y" -AdminPassword "myNewP@ssword"

Get-AzureSqlDatabaseServer

New-AzureSqlDatabaseServer

Remove-AzureSqlDatabaseServer