New-​Azure​Sql​Database​Server

Creates an Azure SQL Database server.

Syntax

New-AzureSqlDatabaseServer
   -AdministratorLogin <String>
   -AdministratorLoginPassword <String>
   [-Force]
   -Location <String>
   [-Profile <AzureSMProfile>]
   [-Version <Single>]
   [-Confirm]
   [-WhatIf]
   [<CommonParameters>]

Description

The New-AzureSqlDatabaseServer cmdlet creates an instance of Azure SQL Database Server in the current subscription.

Examples

Example 1: Create a server

PS C:\>New-AzureSqlDatabaseServer -Location "East US" -AdministratorLogin "AdminLogin" -AdministratorLoginPassword "AdminPassword"

This command creates a version 11 Azure SQL Database server.

Example 2: Create a version 12 server

PS C:\>New-AzureSqlDatabaseServer -Location "East US" -AdministratorLogin "AdminLogin" -AdministratorLoginPassword "AdminPassword" -Version "12.0"

This command creates a version 12 server.

Required Parameters

-AdministratorLogin

Specifies the administrator account name for the new Azure SQL Database server.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-AdministratorLoginPassword

Specifies the administrator account password for the Azure SQL Database server. You must specify a strong password. For more information, see Strong Passwords (http://go.microsoft.com/fwlink/p/?LinkId=154152) at the Microsoft Developer Network.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Location

Specifies the location of the data center where this cmdlet creates the server. For more information, see Azure Regions (http://azure.microsoft.com/regions/#services) in the Azure library.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-Force

Forces the command to run without asking for user confirmation.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Profile

Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.

Type:AzureSMProfile
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Version

Specifies the version of the new server. Valid values are: 2.0 and 12.0.

Type:Single
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf

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

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False

Outputs

Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerContext