Access to Azure storage container lost - Operating system error code 5 (Access is denied)

Question

Hello,

I have created a DATABASE SCOPED CREDENTIAL, CREDENTIAL and an EXTERNAL DATA SOURCE on an SQL Server database (not Azure) and was able to access blobs on the storage recently created.

However, I lost access the next day. I have read suggestions how to debug but still couldn't resolve the issue.

For example: https://learn.microsoft.com/en-us/answers/questions/124104/cannot-bulk-load-because-the-file-sqlfiles-csv-cou

I am getting this error:

Cannot bulk load because the file [FILE NAME FOLLOWS] could not be opened.

Operating system error code 5(Access is denied.).

I am not sure if it's a firewall issue. As I said, it worked yesterday. I have rotated the SAS key and recreated credentials and data source.

Answer 1

Hi,@Anatoli Titarev I'm glad that you were able to resolve your issue, and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Issue: You have lost access to an Azure storage container and are receiving an "Operating system error code 5 (Access is denied)" message when trying to access a file. you have created a DATABASE SCOPED CREDENTIAL, CREDENTIAL, and an EXTERNAL DATA SOURCE on an SQL Server database (not Azure) and were able to access blobs on the storage recently created.

Solution: You were able to resolve the issue by identifying that the access had expired quickly and that you had mistakenly added a new token.

If you have any other questions or are still running into more issues, please let me know.
Thank you again for your time and patience throughout this issue.

Regards

Geetha

Answer 2

Thank you, GeethaThatipatri-MSFT, I followed your advice.