The SQL Server error log contains user-defined events and certain system events you can use for troubleshooting. The errors and the informational data will be stored in the error logs. The data will be huge and sometimes it will be difficult to find the information or error from it.
Below is the query to retrieve the complete log from SSMS.
If you want to search through this log, you can use the below syntaxes.
To know on which port SQL Server is listening on –
To know the CLR version loaded in the SQL Server –
To know the authentication mode –
If you observe the syntax, I’ve provided two key-words to filter and fetch the required information. The count can be increased.