Skip to content

Latest commit

 

History

History
44 lines (36 loc) · 2.62 KB

File metadata and controls

44 lines (36 loc) · 2.62 KB
title Viewing the Windows Application Log
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology configuration
ms.topic conceptual
helpviewer_keywords
application logs [SQL Server]
Windows application logs [SQL Server]
viewing Windows application logs
errors [SQL Server], logs
system logs [SQL Server]
security logs [SQL Server]
displaying Windows application logs
logs [SQL Server], Windows application logs
ms.assetid f9853b74-7db7-47cc-b957-e49ed5bc0a1a
author markingmyname
ms.author maghan
monikerRange >=sql-server-2016||=sqlallproducts-allversions

Viewing the Windows Application Log

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly] When [!INCLUDEssNoVersion] is configured to use the Microsoft Windows application log, each [!INCLUDEssNoVersion] session writes new events to that log. Unlike the [!INCLUDEssNoVersion] error log, a new application log is not created each time you start an instance of [!INCLUDEssNoVersion].

View and manage the Windows application log by using Windows Event Viewer or the Log Viewer in [!INCLUDEssManStudioFull].

There are three logs that can be viewed with Event Viewer.

Windows log type Description
System log Records events logged by the Windows operating system components. For example, the failure of a driver or other system component to load during startup is recorded in the system log.
Security log Records security events, such as failed login attempts. This helps track changes to the security system and identify possible breaches to security. For example, attempts to log on to the system may be recorded in the security log, depending on the audit settings in the User Manager.

Only members of the sysadmin fixed server role can view the security log.
Application log Records events that are logged by applications. For example, a database application might record a file error in the application log.

For more information about using Event Viewer, managing the application log, and understanding the information it presents, see the Windows documentation.

To view the Windows application log

View the Windows Application Log (Windows)