From the course: SQL Server 2014 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Auditing logins

Auditing logins - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Auditing logins

- One of the common things we'd like to monitor in SQL Server 2014 is who is logging into our server, and also unsuccessful attempts to log into our server. These are interesting from a security point of view. Obviously if we're seeing a great number of unsuccessful logins, that could be a sign that someone is trying to breach our security. But also in many trouble-shooting situations, we'd like to know who is logging in, or who is having trouble logging in, and why. One of the more common things I trouble-shoot in my career is a failed connection to SQL server. And so when the end-user calls me, they insist that they're putting in the right IP address, the right username, and the right password. But I don't really know if that's true. They could be accidentally putting in the wrong password, they could be using the wrong username. So if I am monitoring logins, I can go to the logs and check and see, did they successfully login, or was there a problem based on password, or was there a…

Contents