Puzzled about Credential Details for Vertically Sc

问题:

I am trying to upscale and downscale my SQL Azure instances using Azure Automation. I am using a gallery runbook called "Set-AzureSqlDatabaseEdition.ps1" which has been created by Joseph Idziorek.

The link is: SQL Azure vertical scale Runbook The parameter examples are:

.EXAMPLE for Set-AzureSqlDatabaseEdition  

    -SqlServerName bzb98er9bp   

    -DatabaseName myDatabase 

    -Edition Premium 

    -PerfLevel P1 

    -Credential myCredential  

However I am confused what should go into "Crediential". Is this the SQLServer Admin Username or something else? Is it something I create in Azure Automation Assets?

Thanks.

回答1:

One needs to create a credential asset using the "SQLServer" credentials not AD, and then use the name of this for the Credential parameter value.