Lesson Learned #42: Creating an alias for my Azure SQL Database Server
Published Mar 13 2019 07:00 PM 1,725 Views
First published on MSDN on Apr 23, 2018
Today, I've been working on a service request very interesting.

If you need to create an alias for your Azure SQL Server, you have the PowerShell cmdlet called: New-AzureRmSqlServerDnsAlias.

The syntax to use is:

[string]$SubscriptionId = "xxxxxxxxxxxxxxxxxxxxx"
$azureCtx = Set-AzureRMConteXt -SubscriptionId $SubscriptionId
New-AzureRmSqlServerDnsAlias -ResourceGroupname 'Resource group' -ServerName myserver1 -DnsAliasName myserver12

Remember that there is not needed in the servername and dnsaliasname parameters use the domain .database.windows.net just only you need to specify the servername.

Version history
Last update:
‎Mar 13 2019 07:00 PM
Updated by: