View the SQL Server error log (SSMS) - SQL Server
docs.microsoft.com › en-us › sqlOct 25, 2021 · In Object Explorer, connect to an instance of SQL Server, and then expand that instance. Find and expand the Management section (assuming you have permissions to see it). Right-click SQL Server Logs, select View, and then choose SQL Server Log. The Log File Viewer appears (it might take a moment) with a list of logs for you to view. Next steps