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
Search found 5 matches
- Fri Feb 05, 2021 12:58 pm
- Forum: Open Source Nagios Projects
- Topic: MSSQL --UNKNOWN: Invalid characters in the hostname.
- Replies: 0
- Views: 2456
- 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.
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.
- 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'
$USER1$='DOMAIN\\USERNAME'
- 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
(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
- 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...