Azure SQL Database Auditing Data Access

Question

I'm running with a SQL Database in Azure and have setup auditing through the portal and enabled all options. I'm connecting to the DB through SQL Server Management Studio using the .secure. option to make sure stuff is audited but when I run a SQL query against the DB in SSMS I don't see any "Data Access" auditing.

Am I misunderstanding what "Data Access" is actually auditing.

I've checked the audit table and I see things like my login but nothing resembling any of the queries I've done.

Si

Yup as I said I replaced my SSMS connection string with the .secure. version — Simon
– Simon, Commented Jan 25, 2015 at 20:22
great question, I am still waiting to my connections and queries to be appear. fingers crossed. — Teoman shipahi
– Teoman shipahi, Commented Jun 1, 2015 at 2:52

Simon · Accepted Answer · 2015-01-25 20:30:02Z

2

Not an answer as such but am now seeing the Data Access requests although it looks like it took hours to appear. However I've now run some tests and the data seems to appear pretty quickly so I can only guess there was some initial delay in setting up the full auditing. Thanks for the responses.

answered Jan 25, 2015 at 20:30

Simon

1,7031 gold badge15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Teoman shipahi Over a year ago

So you are saying, there was a delay initially and it has been evolved to be instant feedback?

Simon W · Accepted Answer · 2015-01-25 06:56:11Z

0

You should have been prompted to setup an Azure Storage Account into which the audit logging information is written. You then need to download that data to analyse it.

There is a very good "how to" on the Azure documentation site on configuration of this new feature and how to consume the data it captures.

answered Jan 25, 2015 at 6:56

Simon W

5,4083 gold badges27 silver badges35 bronze badges

1 Comment

Simon Over a year ago

Yup I setup the storage and have the spreadsheet setup that Microsoft provides and I see data in there just none of the requests for data, i.e. I see the login to SSMS but the if I do a select * from X I don't see that in the audit logs. Oh and I followed the How To instructions to a tee

Collectives™ on Stack Overflow

Azure SQL Database Auditing Data Access

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related