Search found 28 matches

by eliassal
Mon Dec 03, 2018 12:51 pm
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

Some good news, after upgrading I readded my sql server monitoring with windows authentication, and everything works like a charm. However, in the monitoring config wizard, I gave it of course the same exact FQDN of the server without the instance name, it updated the existing one which had the same...
by eliassal
Mon Dec 03, 2018 12:27 pm
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

I gave it a go the uypgrade, ran the following 2 commands wget -O upgrade.sh https://assets.nagios.com/downloads/nagiosxi/upgrade.sh sh ./upgrade.sh as indicated in the doc, everythinh worked like a charm. I reran the freepages service for sql, I get [nagios@localhost.localdomain ~]$ /usr/local/nagi...
by eliassal
Mon Dec 03, 2018 11:41 am
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

Thanks yes please, do the feature request, appreciate it
by eliassal
Sat Dec 01, 2018 8:00 am
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

One of the services which was working fine, since 1 hour started to behave in the same way as stolen pages, the service is the "MSSQL Free Pages". In the UI I am getting COMMAND: /usr/local/nagios/libexec/check_mssql_server.py -H 192.168.1.69 -U 'sa' -P 'pepv1met' -I 'SC2K12' --freepages -...
by eliassal
Sat Dec 01, 2018 7:53 am
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

By the way, in the UI, I have a link "Check for Updates", I clicked on it, I was taken to a page where it is indicated Product Update Check An Update Is Available! Your installation of Nagios XI 2014R2.6 is outdated and should be upgraded. The latest version of Nagios XI is 5.5.7, which wa...
by eliassal
Sat Dec 01, 2018 7:50 am
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

I did and PIP is installed as you can notice Downloading Packages: python-pip-7.1.0-1.el6.noarch.rpm | 1.5 MB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : python-pip-7.1.0-1.el6.noarch 1/1 Verifying : python-pip-7.1.0-1.el6.noarch...
by eliassal
Fri Nov 30, 2018 4:39 pm
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

Sorry, but this is a VM provided by Nagios, I havn't installed anything, if I remember well, 6 or 7 months back I downloaded the VM and just running it, nothing is done on my side.
For the sake of discussion I know a little bit linux but not un expert nor PIP
by eliassal
Fri Nov 30, 2018 2:46 pm
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

Yes, it is the only service, all others are working correctly. Hereunder the output of each command, only the 3rd one in not working, it seems that it is not correct I can't say for the win authentication as it never worked for any service as you know. uname -a Linux localhost.localdomain 2.6.32-504...
by eliassal
Fri Nov 30, 2018 12:22 pm
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

I am more than sure it won't work without the name of the instance as it will go to the default instance in which sa is disabled. Anyway, I gave it a go and here is the rsults SQL Server message 18456, severity 14, state 1, line 1: Login failed for user 'sa'. DB-Lib error message 18456, severity 14:...
by eliassal
Fri Nov 30, 2018 6:04 am
Forum: Nagios XI
Topic: MSSQL - Adaptive Server connection failed
Replies: 39
Views: 12716

Re: MSSQL - Adaptive Server connection failed

echo $? gave this

1