Login Errors since last reboot

[justine]

Hi,
I would like to know more about logon errors. We have added an SQL server and had this "Login Errors since last reboot is 2".
Does the parameter \\Server\\Logon Errors checks for SQL Server login?
How can i verify this? It seems that it is not visible in the event viewer.

[slansing]

Which plugin are you using to monitor this server? We can take a look at the return codes of the plugin but it may be something specifically sent by the MSSQL server, in which case the Microsoft site should have them listed.

[justine]

I used Windows server upon configuration. Choose Logon Errors under performance counters.
The command used is check_xi_service_nsclient ($USER1$/check_nt -H $HOSTADDRESS$ -s "$ARG1$" -p 12489 -v $ARG2$ $ARG3$ $ARG4$)
ARG2: Counter and ARG3: -l "\\Server\\Errors System","Login Errors since last reboot is %.f" -w 5 -c 20

[sreinhardt]

According to msdn, YES sql logons do trigger the logon event which will add to that performance counter. There may be ways to disabled it triggering the event if you wish, the event in particular only creates an event log entry and performance counter increase to my knowledge.

http://msdn.microsoft.com/en-us/library/bb326598.aspx