Administer Operator Categories and Custom Operator Groups › Configuring Operator Categories › Enable Windows Integrated Security for the JDBC Module for MSSQL Server

Enable Windows Integrated Security for the JDBC Module for MSSQL Server

You can enable operators in the Databases category for the Microsoft SQL Server (MSSQL) to use integrated security. These operators can use integrated security when connecting to touchpoints on hosts running on Windows operating systems.

A Databases operator is an operator in the Databases category. Target hosts are hosts with an agent or Orchestrator. For each target host that a Databases operator can access, copy sqljdbc_auth.dll to the system path of that host. This process configures the Databases category for MSSQL so it uses integrated security with Windows Authentication.

You can enable Windows integrated security for the Databases category for MSSQL Server.

Follow these steps:

1. If you use the Microsoft SQL Server driver version that is packaged with CA Process Automation, download version 3.0 of the driver from the Microsoft website. Otherwise, locate (or download again) the complete version of the driver.
2. Locate the packaged or downloaded sqljdbc_auth.dll that corresponds to the hardware where the agent or Orchestrator is running.
3. Copy sqljdbc_auth.dll to a folder on the system path of each CA Process Automation agent or Orchestrator that is running in a Windows operating environment.

   To determine the system path, take one of the following actions:

   • Enter the following command at a command prompt:

     echo %PATH%
     

     The system path displays.

   • Go to Start, Settings, Control Panel, System, Advanced (Advanced System Settings), Environment Variables. The system path displays in the PATH variable.
4. Restart the agent or Orchestrator.

Notes:

• When you create a connection URL without integrated security, you specify the user name and password. To use integrated security, do not specify the user name and password.
• Append ;integratedSecurity=true to the Connection URL. For example:

  jdbc:sqlserver://localhost ... ;integratedSecurity=true