Share via

Error when connecting BLOB of container in MSSQL

youngsik Ahn 81 Reputation points
2022-12-31T05:02:20.837+00:00

I created a SAS token key in the web portal container BLOB.

I want to execute DB Backup by connecting to MSSQL using this SAS token.

However, after trying several times, an error occurs.

Below are the order and execution commands I processed.

275172-image.png

I created a SAS for the dbbak folder.

275148-image.png

I have created a SAS Token and URL.

275192-image.png

I created a credential.

275160-image.png

I ran the DB backup command.

275201-image.png

An error occurs when the backup is executed.

error message

---------------

Msg 3298, Level 16, State 2, Line 33
Backup/Restore to URL device error: Error while decoding the storage key.
Msg 3013, Level 16, State 1, Line 33
BACKUP DATABASE is terminating abnormally.

---------------

For reference, the version of MSSQL being used is MSSQL 2014.

I am wondering what is the wrong procedure or problem for me to connect to the BLOB.
I hope someone can guide me.
Thanks.

Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,550 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,212 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.