`RESTORE FILELISTONLY FROM URL = '' WITH CREDENTIAL = ''` fails in SQL Server 2016.

Copied script from SQL Server 2012 environment, successfully restoring from Azure Storage Container, with create credential statement, and it failed in 2016.

Error message "Forbidden".

Only after logging into the Azure Portal, creating a Shared Access Signature for the container, could I execute the restore, and only by *not specifying* the credential did the restore work.

No documentation advises that a SAS (Shared Access Signature) is required in SQL Server 2016 for Azure container backup / restore.

Is there another way to use T-SQL to access blob backups on Azure storage containers in SQL Server 2016, than using SAS?

[MSDN - SQL Server Backup to URL SQL Server 2016][1]


Looking at the MSDN tutorial on how to configure the backup service SQL 2016 introduces, a SAS is used. Refer [MSDN Tut on SQL 2016 backup service][2]


  [1]: https://msdn.microsoft.com/en-us/library/dn435916.aspx#Examples "MSDN page for Backup to URL"
  [2]: https://msdn.microsoft.com/library/dn466438.aspx "Tutorial: Using the Microsoft Azure Blob storage service with SQL Server 2016 databases"