Total Page Preview:   000000004253

How to create Azure SQL Server using powershell

In this article I am going to explain how to create azure SQL Server using powershell.

Create Azure SQL Server using powershell command with ARM :

#-------- TenantId -------------#

Get TenantId from the Azure Portal: 
Get TenantId In Azure
$tenantid = 'd29b7a9b-6edb-4720-99a8-3c5c6c3eeeb0'
#------------- Your UserId and Password -----------------------#
$username =  ''
$password = 'xxxxxxxxxxx' | ConvertTo-SecureString -asPlainText -Force
$cred = New-Object System.Management.Automation.PSCredential($username, $password)
Login-AzureRmAccount -TenantId $tenantid -Credential $cred
#------------------------If you have multiple subscriptionId in single account-----------#
$subscriptionId = (Get-AzureRmSubscription | Out-GridView -Title "Select an Azure Subscription …" -PassThru).SubscriptionId
#------------------------for single subscriptionId -----------#
$subscriptionId = (Get-AzureRmSubscription).SubscriptionId
$rgroup= Read-Host -Prompt 'Enter Resource Group name'
$serverlocation = Read-Host -Prompt 'Please Enter SQL Server Location'
#----- Exists and Creation of Resouse groups ----------------#
    $location = Get-AzureRmResourceGroup -Name $rgroup -ErrorAction SilentlyContinue
    $keylocation = $location.Location 
    $location = New-AzureRmResourceGroup -Name $rgroup -Location $serverlocation  
    $keylocation = $location.Location   
if ($location -eq '' -or $location -eq $null)
    $location = New-AzureRmResourceGroup -Name $rgroup -Location $serverlocation 
    $keylocation = $location.Location
#--- Creating Azure SQL Server -----#
$serverName = Read-Host -Prompt  'Please Enter Azure SQL Server Name'
$serverName = $serverName.ToLower()
$sqlusername = Read-Host -Prompt  'Please Enter SQL Server Login'
$sqlpass = Read-Host -Prompt  'Enter SQL Server Login Password'
$sqlpass = $sqlpass | ConvertTo-SecureString -asPlainText -Force
$cred = New-Object TypeName System.Management.Automation.PSCredential –ArgumentList $sqlusername, $sqlpass
$sqlserver = New-AzureRmSqlServer -ResourceGroupName $rgroup -ServerName $serverName `
 -Location $serverlocation -SqlAdministratorCredentials $cred -ServerVersion '12.0'
Create Azure SQL Server using powershell command with ARM :
Create Azure SQL Server Using Powershell
By Brijesh Kumar


Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn :





Facebook User: