Quick tutorial:
In this tutorial, I am going to show you how we as System Administrator can review the SQL log files. For example, there is a common ticket that some users DBA are complaining about failed to login to SQL server. How can you as IT Member check it on?
What you have to do is to make so “Logging Auditing” is allowed on the Instance:
And now I will try to login to the SQL with the wrong user in purpose just to SQL_make some events log:
Probably we should receive the message:
Now we will go to Log Files on the Default Path:
“Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\logs”
And look for logs:
I have opened the “Log_1”, and here you can that the log opened on the SQL Server Profiler tools which allow us to review the log.
You can also trace about connection attempts, who tried, who should try at all.
Try to make use of this logging, they give us a lot of information and enrich our knowledge.