MS SQL

[lmiltchev]

I don't think you can use a windows authentication - see the documentation:

Code: Select all

Required Options:
    -H HOSTNAME, --hostname=HOSTNAME
                        Specify MSSQL Server Address
    -U USER, --user=USER
                        Specify MSSQL User Name
    -P PASSWORD, --password=PASSWORD
                        Specify MSSQL Password
    -T TABLE, --table=TABLE
                        Specify MSSQL Table

[scottwilkerson]

I believe lmiltchev is correct, this will only work with SQL server credentials, not Windows domain credentials, even if the Windows Domain user has access to the MSSQL Server

[nscott]

Yes, those two are absolutely correct. Also, I was mistaken with my previous post, I had misread yours and thought you wanted something that you did not. Please be sure make sure you have the latest MSSQL wizard, I just uploaded the latest version to our assets site, so be sure to use that one.

[ecarrasq]

I got the MS SQL Admin to create me a local account, as you specified, and I downloaded the latest MS SQL Database Wizard. Once I try these out, I'll let you know how it worked.

Thank you for all you do,
Eddie

[scottwilkerson]

Thanks for the update.

[ecarrasq]

I obtained local read only access to the database, I installed the new "MSSQL Server/Database/Query" wizards, ran them, but I get:

(Service Check Timed Out)

Please help.

Thanks,
Eddie

[scottwilkerson]

Can you temporarily disable iptables on the nagioxi server and then force one of the checks to see if that makes a difference

Code: Select all

service iptables stop

Then force the check on one of these services to see if it can connect
restore iptables

Code: Select all

service iptables start

[ecarrasq]

I "service iptables stop" and tried it again, but no luck.

[scottwilkerson]

Can you send your current command for one of the checks.. (removing any sensitive data)

[ecarrasq]

Here is the full configuration file generated by NagiosXi MSSQL Database Wizard.

###############################################################################
#
# Service configuration file
#
# Created by: Nagios QL Version 3.0.3
# Date: 2012-06-21 10:17:56
# Version: Nagios 3.x config file
#
# --- DO NOT EDIT THIS FILE BY HAND ---
# Nagios QL will overwite all manual settings during the next update
#
###############################################################################

define service {
host_name <MSSQL>
service_description MSSQL Active Transactions
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --activetrans --warning 10 --critical 20
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Connection Time
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --time2connect --warning 1 --critical 5
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Log Cache Hit Rate
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logcachehit --warning 0:95 --critical 0:97
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Log File Usage
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logfileusage --warning 0:80 --critical 0:90
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Log Flush Wait Time
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logwait --warning 100 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Log Growths
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --loggrowths --warning 20 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Log Shrinks
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logshrinks --warning 20 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Log Truncations
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --logtruncs --warning 100 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

define service {
host_name <MSSQL>
service_description MSSQL Transactions / Sec
use xiwizard_mssqldatabase_service
check_command check_xi_mssql_database!-H <mssql IP address> -U <local username> -P <user's password> -T 'stepwise_subset' -I db001a -p 1433 --transpsec --warning 10 --critical 20
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 0
_xiwizard mssqldatabase
register 1
}

###############################################################################
#
# Service configuration file
#
# END OF FILE
#
###############################################################################