Automic Workload Automation

Back to discussions
Expand all | Collapse all

How to make sure JWP starts with NT Authentication instead of SQL Authentication ?

  • 1.  How to make sure JWP starts with NT Authentication instead of SQL Authentication ?

    Posted 01-09-2018 03:43 PM
    How to make sure JWP starts with NT Authentication instead of SQL Authentication ?

    Please download the latest 6.2.2 JDBC driver from Microsoft. Then, please do the following steps: 

    -Rename mssql-jdbc-6.2.2.jre8.jar to sqljdbc4.jar and put it in <AE installation>\bin\lib and 
    -Put the sqljdbc_auth.dll in <AE installation>\bin 

    -Make sure to use integratedSecurity=true on the line below in the Ucsrv.ini file 

    [JDBC] 
    SQLDRIVERCONNECT=jdbc:sqlserver://10.2.128.254;databaseName=AEWNT;integratedSecurity=true 


  • 2.  How to make sure JWP starts with NT Authentication instead of SQL Authentication ?

    Posted 01-09-2018 05:12 PM
    The updated MS SQL jdbc driver fixed another problem with Windows authentication inside a SQL job utilizing a connection object with integratedSecurity=true.


  • 3.  How to make sure JWP starts with NT Authentication instead of SQL Authentication ?

    Posted 01-09-2018 05:52 PM
    In my case I did not have to rename the jdbc jar file. It still uses the original file name: mssql-jdbc-6.2.2.jre8.jar