Host in check_mssql_sproc

[Quim]

Hello

We create a new SQL Server and we need to change host (we have some checks to monitoring Store Procedures) in checks.

In this example, Host is DBA6. Where does it define?

define service{
use generic-service
host_name empbrasrv01
service_description OutOfMemory ATS
check_command check_mssql_sproc_empbrasql04!-H DBA6 -d ATS -u sa -P 0ipshahto -p 'Exception_Manager_Monitor_OutOfMemory "empbrasrv01"' -c 1 -w 1
}

Our Nagios version is Nagios® Core™ 4.4.5

Any help?
Thanks

[Quim]

Hi

we find the solution: modifying etc/odbc.ini. In this file you can edit odbc connections. Then you should change, thus is necessary, command and check.

I hope you userful.

thanks

[benjaminsmith]

Hi Quim,

Thanks for posting your solution to the Nagios community.

We'll go ahead and mark this as resolved. Please open another thread if you have any new issues.