Skip to main content
Database Administrators

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Notice removed Draw attention by CommunityBot
Bounty Ended with no winning answer by CommunityBot
Tweeted twitter.com/StackDBAs/status/786516211362304000
Added links to relevant MSDN material
Source Link
Alocyte
Alocyte
  • 418
  • 3
  • 16

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

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

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?

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

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

Notice added Draw attention by Alocyte
Bounty Started worth 50 reputation by Alocyte
added 20 characters in body; edited tags; edited title
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

SQL Server 2016: Backup to Azure Storage Container: Shared Access Signature the only way?

RESTORE FILELISTONLY FROM URL = '' WITH CREDENTIAL = ''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 SPECIFYINGnot 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?

SQL Server 2016: Backup to Azure Storage Container: Shared Access Signature the only way?

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

Copied script from SQL 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 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?

Backup to Azure Storage Container: Shared Access Signature the only way?

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?

Source Link
Alocyte
Alocyte
  • 418
  • 3
  • 16

SQL Server 2016: Backup to Azure Storage Container: Shared Access Signature the only way?

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

Copied script from SQL 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 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?