Viewing the SQL Server Error Log

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:

Viewing SQL Server

And now I will try to login to the SQL with the wrong user in purpose just to SQL_make some events log:

Viewing SQL Server

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:

Viewing SQL Server

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.

SQL Error 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.