Forum Discussion
Justinrr07
Jun 21, 2021Copper Contributor
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".
- SqlazCopper 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.