Training module "Architect modern applications using Azure SQL Database" gives incorrect data.

Question

I'm just trying to do the training module "Architect modern applications using Azure SQL Database", exercise "Deploy and configure Azure SQL Database", task "Set up the database's schema with T-SQL". Screenshot of the task itself:

And so in the file "01-set-up-database.ipynb" everything goes well until it tells the following:

So I'm simply unable to continue doing the training course because of this. I've already searched for the fix fox 3 days and my only thought is that the SAS token has already expired to get access to that blob storage but I can't generate new token to that storage because I don't have an access to that storage.

This question is related to the following Learning Module

Answer 1

Hi Ткачов Артур,

Thanks for reaching out to us on Microsoft Q&A forum.

1.  If you're unable to generate a new SAS token for blob storage, contact your system administrator or support representative for assistance. Clearly explain your situation and request help in obtaining a valid SAS token.

2. Verify whether the SAS token has expired. SAS tokens have a limited validity period, so ask someone with token generation privileges to create a new one for you. Ensure it has the necessary permissions and an appropriate expiry time.

3.Confirm that the SAS token you're using grants the required permissions for accessing the blob storage. Without correct permissions, you won't be able to interact with the storage.

4. Explore alternative methods to access the necessary resources if obtaining a new SAS token directly is not feasible. For instance, consider cloning the required data or accessing it temporarily through a colleague's authorized account.

Based on the error message it indicates that the server failed to authenticate the request and that you should check the value of the Authorization header to make sure it is formed correctly, including the signature.

Can you also re-confirm the access keys were not refreshed etc., by confirming they match with the keys in the Portal?

• Are you trying to upload to Files or blob storage?
• Verify System Time(Make sure that the system time on the machine generating the SAS token is accurate. A significant time discrepancy could lead to authentication failures)
• Try to regenerate New SAS token and upload
• For testing purpose can you upload using Storage account key and Storage explorer or azcopy tool?

Here are some things you can check to troubleshoot the issue:

1. Check if the SAS token has expired. Even though the SAS token has valid dates, it is possible that it has expired. Make sure that the SAS token is still valid and has not expired.
2. Check if the SAS token has the correct permissions. Make sure that the SAS token has the correct permissions to upload files to the Azure storage account.
3. Check if the SAS token has the correct format. Make sure that the SAS token has the correct format and that it includes all the required parameters.
4. Check if there are any network connectivity issues. Make sure that there are no network connectivity issues that may be preventing the request from being authenticated.

Additional Information:

Reference link : https://docs.microsoft.com/en-us/azure/storage/common/storage-sas-overview#best-practices-when-using-sas:
Based on the error message there is similar thread discussion here which gives some idea on your issue.   

https://learn.microsoft.com/en-us/azure/storage/common/storage-sas-overview

https://learn.microsoft.com/en-us/azure/storage/blobs/storage-quickstart-blobs-dotnet?tabs=visual-studio%2Cmanaged-identity%2Croles-azure-portal%2Csign-in-azure-cli%2Cidentity-visual-studio&pivots=blob-storage-quickstart-scratch

If you are still running into issues, kindly attach the screenshots of the error you are getting. We will be glad to assist you.

If the information is helpful, please Accept Answer & Upvote so that it would be helpful to other community members.