Search found 7 matches
- Wed Mar 07, 2012 9:40 am
- Forum: Nagios XI
- Topic: Genral Help with MSSQL
- Replies: 10
- Views: 3585
Re: Genral Help with MSSQL
Yes, more or less there are a couple of tests that don't connect (on any servers) but that may be due to something missing on the servers I have no idea as the security works on all the other tests. So out of about 6 MSSQL servers only 1 will not work at all, it must be something missing on the serv...
- Mon Mar 05, 2012 10:11 am
- Forum: Nagios XI
- Topic: Genral Help with MSSQL
- Replies: 10
- Views: 3585
Re: Genral Help with MSSQL
Thanks, I've got it monitoring a couple of servers now and I think just 2 of the tests don't connect on all servers. (the response time ones I think). There is definitely no info on the test until you check it and look at the graph and then this all works.
- Thu Mar 01, 2012 6:47 am
- Forum: Nagios XI
- Topic: Genral Help with MSSQL
- Replies: 10
- Views: 3585
Re: Genral Help with MSSQL
Right i've added the SQL test and only provided the same information as before (No instance name) and the table name is excluded. I have again provided the admin name as domain\\user. It seems to connect and some services come back with either ok or critical results but it does not provide any statu...
- Thu Mar 01, 2012 5:45 am
- Forum: Nagios XI
- Topic: Genral Help with MSSQL
- Replies: 10
- Views: 3585
Re: Genral Help with MSSQL
OK I have a database check on master working using Server\\Administrator on two servers, one is in a domain and the other is a standalone machine. Thats all good. I used the password in this format and left out the instance name but did specify the port (1433). Here is a command: check_xi_mssql_data...
- Wed Feb 29, 2012 12:12 pm
- Forum: Nagios XI
- Topic: Genral Help with MSSQL
- Replies: 10
- Views: 3585
Re: Genral Help with MSSQL
I've tried this a few times and it seems to have no effect.
- Wed Feb 29, 2012 11:16 am
- Forum: Nagios XI
- Topic: Genral Help with MSSQL
- Replies: 10
- Views: 3585
Re: Genral Help with MSSQL
OK following on from this I've worked out where to go on the command line to test so I did the following: cd /usr/local/nagios/libexec ./check_mssql_database.py -H myserver.domain.local -U nagiosusername -P password -T MyDatabaseName --activetrans --warning 10 --critical 20 I get the result now Pyms...
- Wed Feb 29, 2012 7:00 am
- Forum: Nagios XI
- Topic: Genral Help with MSSQL
- Replies: 10
- Views: 3585
Genral Help with MSSQL
Ok, I know nothing about linux, centos etc so my knowledge is less than basic. I downloaded the Nagios XI VM and I have this running. I've managed to get it looking at switches, firewalls (Basically) I have had all kinds of problems with the NSClient++, However I've been trying to monitor my MS SQL ...