Not possible to start JWP using "Windows Authentication".
Article ID: 84442
Updated On:
Products
CA Automic Workload Automation - Automation Engine
CA Automic One Automation
CA Automic Operations Manager
Issue/Introduction
Error Message :
Error message in the JWP log:
20171220/115709.933 - U00003590 UCUDB - DB error: '08S01', 'This driver is not configured for integrated authentication. ClientConnectionId:ada2a0df-50b0-4b18-8650-aaddd25a998d', '0', 'com.microsoft.sqlserver.jdbc.SQLServerException'
20171220/115710.089 - U00003432 Termination of Server 'AE12#WP' initiated
It is not possible to start Automic's Java Worker Process (JWP) using "Windows Authentication".
Error message in the JWP log:
20171220/115709.933 - U00003590 UCUDB - DB error: '08S01', 'This driver is not configured for integrated authentication. ClientConnectionId:ada2a0df-50b0-4b18-8650-aaddd25a998d', '0', 'com.microsoft.sqlserver.jdbc.SQLServerException'
20171220/115710.089 - U00003432 Termination of Server 'AE12#WP' initiated
It is not possible to start Automic's Java Worker Process (JWP) using "Windows Authentication".
Cause
Cause type:
Other
Root Cause: The latest 6.2.2 JDBC driver from Microsoft are required for this to work.
Other
Root Cause: The latest 6.2.2 JDBC driver from Microsoft are required for this to work.
Environment
OS: All Windows
Resolution
Download the latest 6.2.2 JDBC driver from Microsoft and follow these steps:
- Rename mssql-jdbc-6.2.2.jre8.jar to sqljdbc4.jar and put it in <AE installation>\bin\lib directory
- Put the sqljdbc_auth.dll in <AE installation>\bin directory
- Make sure to set the integratedSecurity=true parameter in the SQLDRIVERCONNECT setting for jdbc in the ucsrv.ini file(s).
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Feedback
Powered by
