Windows Authentication fails for other probes but not the data_engine

Document ID : KB000033982
Last Modified Date : 14/02/2018
Show Technical Document Details
The following is an example of log entries you might see in one of the probes mentioned above, after changing from using SQL Server (sa) authentication to Windows authentication:

Feb 11 14:19:20:112 [main, sla_engine] Exception occurs in createConnection com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. Trace: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''.

If this is the case, check the data_engine connection string for the following:

If you have the following line for your connection sring in the data_engine:

parameters = Network Library=dbmssocn;Language=us_english;Integrated Security = SSPI

Change it to:

parameters = Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI

Remove any spaces around the '=' in the Integrated Security section.

Then Deactivate the problem probe and Activate it.