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

[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

[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

[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];