Error Check_odbc

[becerra.felipe12]

Dear Good Day,
I have a check_odbc monitoring which is alerted and I have checked the permissions of the SPQJPRMONI account based on BD_Operaciones and everything is fine.

The error is: CRITICAL: Could not connect to 10.220.6.28:1433 as SPQJPRMONI.
It is a SQL Server 2003.

Please help to solve the problem.

[mbellerue]

Hi @becerra.felipe12, welcome to the forums!

Can you post the full check command that you run against this SQL Server?

[becerra.felipe12]

Hi,



check_command check_odbc!SPQJPRMONI!xxxxxxx!BD_Operaciones!1000!1000



greetings and thanks!

[mbellerue]

Okay, that looks good. Can you show me the command definition for check_odbc?

[becerra.felipe12]

sorry
What do you mean by definition?

[lmiltchev]

This means how your command is configured (defined). The configurations of commands are usually found in the "/usr/local/nagios/etc/objects/commands.cfg" file in Nagios Core. An "example" configuration of the 'check_ping' command would look something like this:

Code: Select all

# 'check_ping' command definition
define command{
        command_name    check_ping
        command_line    $USER1$/check_ping -H $HOSTADDRESS$ -w $ARG1$ -c $ARG2$ -p 5
        }

You should have one for the 'check_odbc' command as well. @mbellerue wanted to see that.