MSSQL Server 2012 ERRORLOG problem

[ozzabix]

Hi,

We want to monitor MSSQL Server 2012 ERROR log with,zabbix active log["D:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG",Lo gin Failed,utf-16le,100] bu it is not worked.

Our environment is CENTOS 7.2 and ZABBIX 3.2.4
Want to monitor Database server is server 2012r2 and MSSQL 2012.

We can monitor all log files on windows server. But SQL server Error log not working.
We chceked error file encoding with notepad++ UCS2-LE BOM and checked it this file on linux it says,file -bi /etc/zabbix/ERRORLOG> text/plain; charset=utf-16le.
After that we copy this file in linux zabbix server and create new log file monitor item.
Like, log[/etc/zabbix/ERRORLOG,Login Failed,utf-16le] and monitor is ok.

We tried all alternative way file encoding,UCS2-LE or UTF-16 on windows server etc. But not changed issue.

Is there any way to solve that problem?

[ozzabix]

Hi,

We want to monitor MSSQL Server 2012 ERROR log with,zabbix active log["D:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG",Lo gin Failed,utf-16le,100] bu it is not worked.

Our environment is CENTOS 7.2 and ZABBIX 3.2.4
Want to monitor Database server is server 2012r2 and MSSQL 2012.

We can monitor all log files on windows server. But SQL server Error log not working.
We chceked error file encoding with notepad++ UCS2-LE BOM and checked it this file on linux it says,file -bi /etc/zabbix/ERRORLOG> text/plain; charset=utf-16le.
After that we copy this file in linux zabbix server and create new log file monitor item.
Like, log[/etc/zabbix/ERRORLOG,Login Failed,utf-16le] and monitor is ok.

We tried all alternative way file encoding,UCS2-LE or UTF-16 on windows server etc. But not changed issue.

Is there any way to solve that problem?

I have tried old version zabbix server version 3.0.8 and it Works perfectly.
log key "log["C:\Users\usr1216\Desktop\ERRORLOG",Login failed,UTF-16]"

I think 3.2.4 has bug about log file monitoring UCS2-LE encoding.