BULK 'http./bulk-storage-location/tmp.json) and including the SAS within the external data source too.Ĭorrect me if i'm wrong, could you help us with little more information for the following?ġ) Are you trying to connect local sqldb or SQL server from the storage emulator from the same machine?Ģ) Are you trying to connect storage emulator(which is configured with the storage explorer for local development scenarios) from the SSMS using above sql query ?ģ) Are you trying to connect local storage emulator from another machine?
#AZURE STORAGE EMULATOR LOCALDB FULL#
I've also tried to use the full URL in the select statement (ie. Attempt to select a file that has been uploaded (tmp.json) WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
#AZURE STORAGE EMULATOR LOCALDB PASSWORD#
I've changed the script to the following as per your suggestions with no luck: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'testing' This link when trying to make it work for the emulator. This works fine for an actual blob in azure, however it's when I'm using the storage emulator that it fails. Thanks for getting back to me, unfortunately I'm still unable to access the blobs. I then get the following error: Bad or inaccessible location specified in external data source "localBlobStorage". Attempt to select a file that has been uploaded (cp.json) Create the data source pointing to the blob storage location I created (blob-storage-location)ĬREATE EXTERNAL DATA SOURCE localBlobStorage SECRET = 'Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw=' Create the credentials using the generic storage account keyĬREATE DATABASE SCOPED CREDENTIAL localBlobStorageCredential Here are the steps I'm taking: CREATE MASTER KEY ENCRYPTION BY PASSWORD = '' I'm trying to connect my local SQL Server database instance to the blob storage emulator as an external connection, however I'm getting a "Bad or inaccessible location specified" error.
0 kommentar(er)
