All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
I'm trying to connect to an ODBC datasource using Windows NT Authentication (required by our DBAs). I'm putting the correct login and password in the fields in the ODBC query test, yet I can not logon to the SQL Server. The SQL Server seems to think that I'm attempting to logon as "NT Authority\Anonymous".
You have to adjust datasource properties. You should invoke "ODBC Datasource administrator" and specify "With SQL Server authentication using a login ID and password entered bu the user" option for the certain datasource.
Thats just the point, we can't use SQL Authentication. We have to use a domain logon to access our databases. Hostmonitor doesn't pass the authentication as an NTLM authentication package.
Actually HostMonitor does not send authentication to SQL server because HostMonitor does not connect to SQL server. ODBC driver establishes connection.