From the course: Microsoft SQL Server 2016 Essential Training

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Audit logins

Audit logins - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial Buy for my team

Audit logins

“

- [Instructor] In addition to reviewing the logs we also have some options about what information goes into the logs and one thing I like to change from the default settings in SQL Server 2016 is how we log successful and failed login attempts. Here in Object Explorer, I'm going to select the very top item that represents the name of my SQL server. Right click on that and go to properties. In the properties window I'll open up the security page and we'll see that the login auditing is set to log failed logins only. I'd like to set that to both failed and successful logins and then hit okay. Now that I've done that I'd like to generate a few log entries. So I'll hit connect to database engine and I'll do it once successfully and then I'll hit connect to database engine again and I'll do it unsuccessfully. I'll put in a bad password on purpose and I get an error saying it failed, hit okay. Hit cancel and now let's go…

Contents