Analytics backend does not start.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Starting the Analytics backend ends with: "This driver is not configured for integrated authentication" although the MS SQL JDBC connection string in the application.properties contains the parameter IntegratedSecurity=true.

datasource.ae.url=jdbc:sqlserver://;serverName=Server_Name;port=1433;databaseName=DB_Name;TrustServerCertificate=true;AutoTranslate=false,IntegratedSecurity=true

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:6d7b38fe-a7ed-4060-a302-f80991f3af89

Environment

Analytics 21.0.X, 24.X

Cause

Configuration.

Resolution

The file mssql-jdbc_auth-12.4.2.x64.dll was not copied to the folder: C:\Automic\Automation.Platform\Analytics\backend

Once this file was in place Analytics started as expected.