![]() ![]() ![]() Note: An important point to be considered is, for this change to come into effect you need to restart your SQL Server Service. This will audit all the login attempts in Error log. Method 1: Using SQL Server management Studio: Connect instance in Management Studio → Right Click and select server Properties → Security → Under Login Auditing select both failed and Successful logins and click OK. In this article I will go over some of the quick setup that you can do to enable login auditing. It always a good practice as getting login details real time is easy but what if you want to know if you are investigating an issue happened earlier and need to have list of all login attempts during a particular time. ![]() I knew this day was coming and thank fully I already setup login auditing on all our SQL Server instances. Solution: One day my manager called me and asked me to get him details of the people who logged into one of instances a week back between 4-5 PM.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |