question

sakuraime avatar image
0 Votes"
sakuraime asked AnuragSharma-08 commented

Azure sql database xevent blob storage network

https://docs.microsoft.com/en-us/azure/azure-sql/database/xevent-code-event-file


CREATE
DATABASE SCOPED
CREDENTIAL
-- use '.blob.', and not '.queue.' or '.table.' etc.
-- TODO: Assign AzureStorageAccount name, and the associated Container name.
[https://gmstorageaccountxevent.blob.core.windows.net/gmcontainerxevent]
WITH
IDENTITY = 'SHARED ACCESS SIGNATURE', -- "SAS" token.
-- TODO: Paste in the long SasToken string here for Secret, but exclude any leading '?'.
SECRET = 'sv=2014-02-14&sr=c&si=gmpolicysastoken&sig=EjAqjo6Nu5xMLEZEkMkLbeF7TD9v1J8DNB2t8gOKTts%3D'
;
GO




[https://gmstorageaccountxevent.blob.core.windows.net/gmcontainerxevent] << So this blob storage need to allow all network
inorder to let Azure sql to write to blob ...

how to secure it ??

87833-image.png


azure-sql-databaseazure-storage-accounts
image.png (15.4 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anyone has the idea ?

0 Votes 0 ·

Hi @sakuraime, welcome to Microsoft QnA forum.

We can opt for 'Selected Networks' option. There is a lot of ways we can secure it through. We can create a virtual network, we can add IPs to the firewall to provide access, provide access to azure services and all.

Configure Azure Storage firewalls and virtual networks

Please let us know if this is what you are looking for.

0 Votes 0 ·

0 Answers