bulk insert into azure sql from blob with sas says blob does not exist or don't have file access rights.

Question

bulk insert into azure sql from blob with sas says blob does not exist or don't have file access rights.

Tyler Furman 0

Can't bulk insert into azure sql from blob with sas says blob does not exist or don't have file access rights.

I have created a container, in my azure sql db I have made a scoped credential with the secret from the container. I have then made an external data source using that credential with the container name. I have loaded a csv into my container, obtained a sas key for the csv file and then tried to bulk insert with the full path including container, file, and sas, but it keeps giving me the error "Cannot bulk load. The file "https://nicedbcloud.blob.core.windows.net/nice-db/values.csv?<sas token>" does not exist or you don't have file access rights" which makes no sense as I have given it all the necessary ability to work. Additionally, when I take that file url and paste it into a browser it lets me access the file without problem, so why can't I use it in this bulk insert sql?

Hari Babu Vattepally 3,270 Reputation points Microsoft External Staff Moderator

2025-06-19T00:45:42.7533333+00:00
Hi @Tyler Furman,

As per the error message it says that there might be an issue with the permissions or with the path of the file in Azure Blob Storage. Please try the below suggestions to the get the issue fixed.

Please check and verify that the SAS token you generated has the appropriate permissions (at least read access), make sure that sp contains r for the file you are trying to access. Also, please make sure that the token is not expired.

While generating the SAS token through portal it gives with ? . So, while creating the database scoped credential, you should remove the ? from the secret.

If you SAS token is as below:

?sv=2020-08-04&ss=bfqt&srt=sco&sp=rwdlacup&se=2025-07-01T07:00:00Z&st=2025-06-21T23:00:00Z&spr=https,http&sig=...

Please remove the leading ? so the secret becomes:

sv=2020-08-04&ss=bfqt&srt=sco&sp=rwdlacup&se=2025-07-01T07:00:00Z&st=2025-06-21T23:00:00Z&spr=https,http&sig=...

This is issue also could be occurred due to the token restrictions. Please make sure that the SAS token’s st (start time) is in the past and se (expiry time) is in the future relative to the BULK INSERT execution time.

Please check if there is any IP range parameter sip , if there is any please remove the parameter unless your Azure SQL service is accessing the blob from an IP within that range.

However, please check and make sure when we are creating an external data source and a scoped credential. You should let the below objects to handle the SAS token as below. Please do not append the SAS token to the path in your BULK insert command.

Ensure that you are using the SAS token without the leading ? as in the below command:

CREATE DATABASE SCOPED CREDENTIAL MyBlobCredential WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = 'sv=2020-08-04&ss=bfqt&srt=sco&sp=rwdlacup&se=2025-07-01T07:00:00Z&st=2025-06-21T23:00:00Z&spr=https,http&sig=...';

Please make sure that the external data source is configured correctly and points to the right location in Azure Blob Storage as below:

CREATE EXTERNAL DATA SOURCE MyBlobStorage WITH ( TYPE = BLOB_STORAGE, LOCATION = 'https://nicedbcloud.blob.core.windows.net/nice-db', CREDENTIAL = MyBlobCredential );

As you mentioned that you have configured the external data source with the correct SAS token, please use the file name or relative path in your BULK INSERT command as below:

BULK INSERT MyTable FROM 'values.csv' WITH ( DATA_SOURCE = 'MyBlobStorage', FORMAT = 'CSV', FIRSTROW = 2 -- Adjust as needed );

Please check that if your Azure SQL Database is behind a firewall, ensure that the necessary firewall rules are set to allow access to Azure Blob Storage.

For more additional information, please refer the following documents:

Examples of bulk access to data in Azure Blob Storage

Use BULK INSERT or OPENROWSET(BULK...) to import data to SQL Server

If you are still facing the issue, even after trying the above. Please check for the additional logs and error messages which may provide us more information.

I hope this information helps. Please do let us know if you have any further queries.

Please do not forget to “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Hari Babu Vattepally 3,270 Reputation points Microsoft External Staff Moderator

2025-06-19T14:24:14.1566667+00:00

Hi @Tyler Furman,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Hari Babu Vattepally 3,270 Reputation points Microsoft External Staff Moderator

2025-06-20T05:32:28.9966667+00:00

Hi @Tyler Furman,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Tyler Furman 0 Reputation points

2025-06-20T16:04:38.1766667+00:00

Hi Hari,

Thank you for providing that information. My sql is exactly as you have it, and I have made all the necessary checks for how to input the secret, making sure sp, st, se, and sr are all appropriate, as well as fire walls. Can we please meet on a call to discuss this one-to-one? I can't find any issues and I would hope you can more easily help me understand what is occurring.

Thanks,

Tyler
Tyler Furman 0 Reputation points

2025-06-25T00:38:51.1633333+00:00

Hi Kapil,

I wasn't able to get to your message today. I promise to respond first thing tomorrow with all the info and screenshots you requested. I appreciate your continued support.

Thanks,

Tyler
KapilAnanth-MSFT 49,536 Reputation points Microsoft Employee Moderator

2025-06-25T04:41:49.7566667+00:00

Sure @Tyler ,

Please take your time.
Tyler Furman 0 Reputation points

2025-06-25T22:48:11.2233333+00:00

Hi Kapil,

I wasn't able to get to your message today. I promise to respond first thing tomorrow with all the info and screenshots you requested. I appreciate your continued support.

Thanks,

Tyler
Tyler Furman 0 Reputation points

2025-06-25T22:49:03.32+00:00

I was able to get the issue resolved! I was using the wrong name in the FROM section of the bulk insert statement. Thank you for the help and you may now close this ticket.
KarishmaTiwari-MSFT 20,772 Reputation points Microsoft Employee Moderator

2025-06-26T15:23:14.1733333+00:00

@Tyler Furman Thanks for the update. Glad it is resolved for you.

1 answer

Your answer

Hari Babu Vattepally 3,270 Reputation points Microsoft External Staff Moderator

2025-06-19T14:24:14.1566667+00:00

Hi @Tyler Furman,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Hari Babu Vattepally 3,270 Reputation points Microsoft External Staff Moderator

2025-06-20T05:32:28.9966667+00:00

Hi @Tyler Furman,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Tyler Furman 0 Reputation points

2025-06-20T16:04:38.1766667+00:00

Hi Hari,

Thank you for providing that information. My sql is exactly as you have it, and I have made all the necessary checks for how to input the secret, making sure sp, st, se, and sr are all appropriate, as well as fire walls. Can we please meet on a call to discuss this one-to-one? I can't find any issues and I would hope you can more easily help me understand what is occurring.

Thanks,

Tyler
Tyler Furman 0 Reputation points

2025-06-25T00:38:51.1633333+00:00

Hi Kapil,

I wasn't able to get to your message today. I promise to respond first thing tomorrow with all the info and screenshots you requested. I appreciate your continued support.

Thanks,

Tyler
KapilAnanth-MSFT 49,536 Reputation points Microsoft Employee Moderator

2025-06-25T04:41:49.7566667+00:00

Sure @Tyler ,

Please take your time.
Tyler Furman 0 Reputation points

2025-06-25T22:48:11.2233333+00:00

Hi Kapil,

I wasn't able to get to your message today. I promise to respond first thing tomorrow with all the info and screenshots you requested. I appreciate your continued support.

Thanks,

Tyler
Tyler Furman 0 Reputation points

2025-06-25T22:49:03.32+00:00

I was able to get the issue resolved! I was using the wrong name in the FROM section of the bulk insert statement. Thank you for the help and you may now close this ticket.
KarishmaTiwari-MSFT 20,772 Reputation points Microsoft Employee Moderator

2025-06-26T15:23:14.1733333+00:00

@Tyler Furman Thanks for the update. Glad it is resolved for you.

Answer 1

@Tyler Furman ,

Customer's update: I was using the wrong name in the FROM section of the bulk insert statement.

Other Troubleshooting steps:

When you say "when I take that file url and paste it into a browser it lets me access the file without problem"

This indicates the issue could be from the source side
i.e., Azure SQL Server and not the Storage Account.

I suggest you make sure the steps involved are correct according to

Access data in a CSV file referencing a container in an Azure Blob Storage location
Cannot bulk load. The file "xyz" does not exist or you don't have file access

Once done, make sure the user has enough permissions on the SQL Server itself.

See : Permissions
- Requires INSERT and ADMINISTER BULK OPERATIONS permissions. In Azure SQL Database, INSERT and ADMINISTER DATABASE BULK OPERATIONS permissions are required.
Also refer : sql server bulk insert permisisons

If the above does not help too,

Please share the exact SQL Code you are using to perform this operation
Please share the screenshot of the SAS Token permissions (from Portal)
Of course please feel free to blur/hide any PII or sensitive data

Cheers,

Kapil

Share via

bulk insert into azure sql from blob with sas says blob does not exist or don't have file access rights.

1 answer

Your answer