Page 1 of 1

8456, "Login failed for user ' nagios'.DB-Lib error message

Posted: Fri May 22, 2020 1:18 pm
by dbasupport
Hi ,

Any idea on the error

Unknown
(18456, "Login failed for user ' nagios'.DB-Lib error message 20018, severity 14:\
General SQL Server error: Check messages from the SQL Server\\
DB-Lib error message 20002, severity 9:\\
Adaptive Server connection failed (MAMSSQLSNDBOX01.client.ma:1433)\\
")

Regards

Re: 8456, "Login failed for user ' nagios'.DB-Lib error mess

Posted: Fri May 22, 2020 1:34 pm
by benjaminsmith
Hi @dbasupport,

Welcome to the Nagios Community Forum! Is that the output from a check command, if so can you post the full command to the thread?

Also, certainly looks like authentication or network issue, are you using the correct credentials. Is there anything blocking access?

Benjamin

Re: 8456, "Login failed for user ' nagios'.DB-Lib error mess

Posted: Fri May 22, 2020 1:49 pm
by jbrunkow
Are there any special characters in your password? If so, they may be escaping the command... Try making a complex password with just letters and numbers.

What are the nagios user's permissions to the SQL server like?

Code: Select all

SHOW GRANTS FOR [i]user[/i]@[i]localhost[/i];