How to enable Windows Authentication with Integrated Security for the JDBC Module for MSSQL Server

Products

• CA Process Automation Base

Issue/Introduction

This article applies to JDBC operators in ITPAM for MSSQL Server Database with Windows Authentication.

Environment

Release : 4.3.X

Component : Process Automation

Cause

• Require sqljdbc_auth.jar in valid path.
• The user with which the ITPAM service started is considered as the user for making connection to Database.

Resolution

Steps for sqljdbc_auth.jar file:

1. Download the sqljdbc_auth.jar from Microsoft site corresponding to the Operating System where the agent or Orchestrator is running and MSSQL server version.

2. Copy sqljdbc_auth.jar to Java installed locations used by ITPAM as below: 
        X:\Program Files\Java\jdkxxx.xxx\bin
        X:\Program Files\Java\jdkxxx.xxx\jre\bin
   
3. Also, copy sqljdbc_auth.jar to <PAM Installed location>\server\c2o\ext-lib  

4. The jar file also needs to be in any folder in the PATH environment, e.g. C:\Windows\system32

5. Restart Orchestrator or Agent service.

Steps to start ITPAM service with specific user: 

• Stop ITPAM service 
• Modify the Service "Log On" to "This account:" and specify the user details to connect to Database
• Start ITPAM service

To use integrated security, do not specify the user name and password in the Connection URL.
The user with which the ITPAM service started is considered as the user for making connection to Database.

Append ;integratedSecurity=true; to the Connection URL in the operator. For example:
"jdbc:sqlserver://" + "DBServerName" + ":" + 1433 + ";DatabaseName=" + "master" + ";integratedSecurity=true;"