Automic Workload Automation

 View Only

 install AE with windows authentication to MSSQL Server

Jump to  Best Answer
Omer Nuri's profile image
Omer Nuri posted Jul 29, 2024 02:36 AM

Hi everyone,

I try to install AE that connect to the SQL Server database with windows authentication.

OS - windows server 2016

SQL server version - 2022

AE version - 24.0

DSN connection was successfully connected, and also I used this DSN in the DB load ini and I could load the database scheme. 

Jdbc connection string also worked when I installed JWP (needed more properties in the connection string).

But, when I start WP it immediately crash because of SQL driver error:

20240727/201035.731 - U00003592 UCUDB - Status: '28000' Native error: '18456' Msg: 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.'
20240727/201035.731 - U00003590 UCUDB - DB error: 'SQLDriverConnectUtf8', 'ERROR   ', '28000', 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.'

Anyone experienced something like this? I tried to google it and search for solution but couldn’t find one that solved the problem.

Am i missing something in configuration? 

Thank you,

Regards, Omer

Peter Grundler's profile image
Broadcom Knight Peter Grundler  Best Answer

Hi Omer,

the server processes have to be started under the user you have granted in the database. Kindly please check.

regards,
Peter