Author : MD TAREQ HASSAN | Updated : 2021/09/25
Backup to URI Error Converting Value “Standard_XXX” to Type
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 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)
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.
- Update SSMS
- As workaround, use storage account that is created before
Cannot open backup device - Operating system error 50
Cannot open backup device ‘https://xxx.blob.core.windows.net/backups/yyy.bak’. Operating system error 50(The request is not supported.)
SAS token was not generated using “Stored Access Policy”
(Generate SAS using “Stored Access Policy”](/azure-storage/generating-sas-token#generate-sas-token-for-sql-backup-to-url)