Search found 5 matches

by mohan.sharma
Fri Feb 05, 2021 12:58 pm
Forum: Open Source Nagios Projects
Topic: MSSQL --UNKNOWN: Invalid characters in the hostname.
Replies: 0
Views: 2456

MSSQL --UNKNOWN: Invalid characters in the hostname.

Hi All,

I am using MSSQL Query wizard and using simple query but getting error "UNKNOWN: Invalid characters in the hostname."

USE master
SELECT Count(*)
FROM sys.databases
WHERE state_desc!='ONLINE'

Any help
by mohan.sharma
Tue Jan 21, 2020 1:13 pm
Forum: Nagios XI
Topic: master MSSQL Log Cache Hit Rate--Down Status
Replies: 1
Views: 118

master MSSQL Log Cache Hit Rate--Down Status

Hi,

I have connected MSSQL server to monitor the HA 2016 Server using AG Listener but it showing status down because of one service
"master MSSQL Log Cache Hit Rate" unknown status error "<type 'exceptions.ZeroDivisionError'>" remaining services showing ok or warning.
by mohan.sharma
Thu Jan 02, 2020 5:13 pm
Forum: Nagios XI
Topic: Unable to connect to MSSQL using user Macros
Replies: 4
Views: 295

Re: Unable to connect to MSSQL using user Macros

All set by using below format

$USER1$='DOMAIN\\USERNAME'
by mohan.sharma
Thu Jan 02, 2020 5:05 pm
Forum: Nagios XI
Topic: Unable to connect to MSSQL using user Macros
Replies: 4
Views: 295

Re: Unable to connect to MSSQL using user Macros

I am getting below error
(18452, 'Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAd
by mohan.sharma
Thu Jan 02, 2020 4:23 pm
Forum: Nagios XI
Topic: Unable to connect to MSSQL using user Macros
Replies: 4
Views: 295

Unable to connect to MSSQL using user Macros

Hi All, I am getting error when I add service account in user macros. $USER1$=[DOMAIN\USERNAME] $USER2$=PASSWROD When I add new MS SQL server to monitor using user macros 1&2 , it is giving error but when I type domain\username and pass $USER2$ in password it works fine. Please let me know which...