Cmdlets

Choose a cmdlet from the list on the left or search for a specific cmdlet. Choose a cmdlet from the list or search for a specific cmdlet.
About Help  Providers
 

Set-AzureSqlDatabaseServer

Set-AzureSqlDatabaseServer

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

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

Syntax

Set-AzureSqlDatabaseServer [-ServerName] [-AdminPassword] [-Force] [-WhatIf] [-Confirm] [<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

-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

0

Default value

None

Accept pipeline input?

true (ByPropertyName)

Accept wildcard characters?

false

-AdminPassword <String>

The new Administrator account password for your SQL Database Server. You must specify a strong password. For more information, see Strong Passwords (http://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 <SwitchParameter>

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

-WhatIf <SwitchParameter>

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Aliases

None

Required?

false

Position

named

Default value

false

Accept pipeline input?

false

Accept wildcard characters?

false

-Confirm <SwitchParameter>

Prompts you for confirmation before running the cmdlet.

Aliases

None

Required?

false

Position

named

Default value

false

Accept pipeline input?

false

Accept wildcard characters?

false

Input Type

Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerContext

Return Type


Notes

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