Menu

Virtual Geek

Tales from real IT system administrators world and non-production environment

MICROSOFT AZURE POWERSHELL DEPLOYING PAAS SQL DATABASE AS A SERVICE

December 7, 2016 11:15PM

Taking forward  from my previous article MICROSOFT AZURE CREATING AND DEPLOYING PAAS SQL SERVER, DATABASE AS A SERVICE, In this post I will performing same task using Microsoft Azure PowerShell to deploy SQL Server. Very first I will be creating Logical SQL server, As this server is completely taken care by Azure team as shown earlier I don't have any physical access.

New-AzureRmSqlServer -ResourceGroupName 'POC-VPN' -Location 'East US 2' -ServerName 'pocsqlserver01' -ServerVersion '12.0' -SqlAdministratorCredentials (Get-Credential)

Once executed this one-liner powershell command New Cloud SQL server is deployed and ready. It prompt for new SQL server username and password (equivalent to SA user). Make sure server name is on all small letters and no special characters allowed, numbers are accepted.

Microsoft Azure Powershell Resource Group deploy new sql database server paas sql database as a service, New-azurermserver

If command executed successfully it shows the new SQL server information on the screen. Next command will create new database under just created SQL server.

New-AzureRmSqlDatabase -ResourceGroupName 'POC-VPN' -DatabaseName 'pocsqlinstance01' -ServerName 'pocsqlserver01' -Edition Standard -RequestServiceObjectName S0

I have used all the existing information for Resource Group and Server Name, Make sure Database name is in small latters and no special characters allowed, numbers are accepted. Edition is the tier version as chart shown in the previous article, and Requested Service Objective name is Database Size.

Microsoft Azure Powershell Resource Group deploy new sql database server paas sql database as a service, New-azurermserver, New-AzureRMSqlDatabase, Get-Credential

New-AzureRmSqlServerFirewallRule -ServerName 'pocsqlserver01' -ResourceGroupName 'POC-VPN' -FirewallRuleName 'MyLocalServer' -StartIpAddress '45.124.140.122' -EndIpAddress '45.124.140.122'

This command will create new Azure SQL firewall rule, I am adding my desktop's internet public IP where my SQL client is installed. Same test I did in previous post.

Microsoft Azure Powershell Resource Group deploy new sql database server paas sql database as a service, New-AzureRmSqlServerFirewallRule firewall Rules

Go Back

Comment