Microsoft SQL Server source

The SQL Server error log is a standard text file that contains Microsoft SQL Server information and error messages. WinCollect monitors the error log for new events and forwards the events to JSA.

The error log provides meaningful information to assist you in troubleshooting issues or alerting you to potential or existing problems. The error log output includes the time and date the message was logged, the source of the message, and the description of the message. If an error occurs, the log contains the error message number and a description. Microsoft SQL Servers retain backups of the last six error log files.

Table 1: Microsoft SQL Server source parameters
Parameter	Description
Type	Microsoft SQL Server
Root directory	Default Value = C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Log Note: You no longer need to enter the UNC path for remote sources.

Supported versions of Microsoft SQL Server

The WinCollect Microsoft SQL Server plug-in is not supported on versions of Microsoft SQL Server that are designated end-of-life by Microsoft. After the software is beyond the Extended Support End Date, the product might still function as expected. However, Juniper does not make code or vulnerability fixes to resolve WinCollect issues for older software versions.