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 - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.