Hi everyone,
I am having trouble getting my 5.4 appliance to connect to our MSSQL server. It appears I have things configured correctly to make the connection, but the MSSQL server keeps complaining "Login failed for user 'username here'. Reason: Password did not match that for the login provided. [CLIENT: 192.xxx.xxx.xxx]." If I test this username with MSSQL Server Manager from my workstation it logs in with no problem. I have searched the forums but not come up with anything that seems to address the problem I am having. I can/will provide more information if necessary to help with troubleshooting. I have tested from CLI in the zabbix appliance also. "isql -v [SQL Server Instance] user pass" generates the same password mismatch message in the SQL server. I have checked login settings for the user. It is set to SQL Server Authentication.
thanks!
-jon
I am having trouble getting my 5.4 appliance to connect to our MSSQL server. It appears I have things configured correctly to make the connection, but the MSSQL server keeps complaining "Login failed for user 'username here'. Reason: Password did not match that for the login provided. [CLIENT: 192.xxx.xxx.xxx]." If I test this username with MSSQL Server Manager from my workstation it logs in with no problem. I have searched the forums but not come up with anything that seems to address the problem I am having. I can/will provide more information if necessary to help with troubleshooting. I have tested from CLI in the zabbix appliance also. "isql -v [SQL Server Instance] user pass" generates the same password mismatch message in the SQL server. I have checked login settings for the user. It is set to SQL Server Authentication.
thanks!
-jon