Author : MD TAREQ HASSAN | Updated : 2021/09/25

Backup to URI Error Converting Value “Standard_XXX” to Type

Problem:
When trying to backup database to Azure Storage Account Container using SQL Server Management Studio (SSMS) backup to URI wizard, “Error Converting Value “Standard_XXX” to Type” (i.e. “Standard_RAGZRS”) is occured.

Error details

===================================

Error converting value "Standard_GZRS" to type 'Microsoft.SqlServer.Management.ServiceManagement.ResourceManagement.AzureStorageAccountSkuName'. Path 'sku.name', line 1, position 30. (Create Credential)

===================================

Requested value 'Standard_GZRS' was not found. (Newtonsoft.Json)

------------------------------
Program Location:

   at Newtonsoft.Json.Utilities.EnumUtils.ParseEnum(Type enumType, NamingStrategy namingStrategy, String value, Boolean disallowNumber)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EnsureType(JsonReader reader, Object value, CultureInfo culture, JsonContract contract, Type targetType)

backup to azure storage account container error

Reason:
Mismatch between Azure REST API and Azure SDK used in SSMS. In my case, storage account created few months ago was working but for recently created storage account, the error was occurring.

Solution:

Cannot open backup device - Operating system error 50

Error:
Cannot open backup device ‘https://xxx.blob.core.windows.net/backups/yyy.bak’. Operating system error 50(The request is not supported.)

Reason:
SAS token was not generated using “Stored Access Policy”

Solution:*
(Generate SAS using “Stored Access Policy”](/azure-storage/generating-sas-token#generate-sas-token-for-sql-backup-to-url)

Links: