Forum Discussion

Justinrr07's avatar
Justinrr07
Copper Contributor
Jun 21, 2021

Azure SQL Create External Data Source to Azure File Share

Hi I have successfully used the method below to access files from Azure SQL to a Blob container.

CREATE EXTERNAL DATA SOURCE MyAzureBlobStorage
WITH (	TYPE = BLOB_STORAGE, 
		LOCATION = 'https://sqlchoice.blob.core.windows.net/sqlchoice/samples/load-from-azure-blob-storage', 
CREDENTIAL= MyAzureBlobStorageCredential
);

Is it possible to achieve the same thing to a File Share instead of a Blob Container?

CREATE EXTERNAL DATA SOURCE MyAzureFileShare
WITH (	TYPE = BLOB_STORAGE, 
		LOCATION = 'https://*********.file.core.windows.net/asftest', 
		CREDENTIAL= MyAzureBlobStorageCredential
		)

When I try I get the following error:

Bad or inaccessible location specified in external data source "MyAzureFileShare".
  • Sqlaz's avatar
    Sqlaz
    Copper Contributor

    Justinrr07 Looks like the question is more than a year old. Did anyone answer this question?  I could connect to files stored on blobs, but just not from file shares. 

Resources