Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


SQL Server 2016 Database Audit Specification

SQL Server 2016 Database Audit Specification

SQL Server 2016 Database Audit Specification

Hello All!
I am working on getting the Failed_Database_Authentication_Group and Successful_Database_Authentication_Group specifications to work, but my changes do not seem to be taking.

I disable the audit and the database audit specification, I modify the database audit specification, adding



save the changes, enable the audit and then the database audit specification, logout of SSMS and then log back in to SSMS and I do not see any entries with action_id = DAGS. My question is, does this not work the way I am expecting it to? I was thinking that it would record every time a user connects to that server and authenticates to the DB in which the database audit specification was created. I have gone into the same database audit specification and added


ADD (SELECT ON OBJECT::[dbo].[CIB_ThirdPartyProvider] BY [public]) 

and then run a select against that table and it logs the query, but still doesn't seem to log the database authentication.

Am I missing something?

Thanks in advance,

RE: SQL Server 2016 Database Audit Specification

Looking at the MS Docs for that audit group, it says that this audit "Indicates that a principal successfully logged in to a contained database." I'm not sure if it's referring to a true Contained Database or not, but if it is that may be your problem (unless you actually are using a Contained Database).

You may want to try using SUCCESSFUL_LOGIN_GROUP instead, although I believe it tracks every successful login to the server so you may get a lot of results from it.

Hope This Helps!

Eric Cobb | SQL Server Database Administrator
MCSE: Data Platform
MCSE: Data Management and Analytics

"My work is a game, a very serious game." - M.C. Escher

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close