Striim 3.10.1 documentation

Table of Contents

Supporting Active Directory authentication for SQL Server

When Striim or a Forwarding Agent is running in Windows, you may use Active Directory authentication.

  1. Follow the instructions in Installing the Microsoft JDBC driver.Installing the Microsoft JDBC driver

  2. Copy sqljdbc_4.2\enu\auth\x64\sqljdbc_auth.dll from the extracted JDBC driver package to the c:\windows\system32\ directory.

  3. Restart Striim or the Forwarding Agent.

In the source or target adapter properties, enter any values for Username and Password (they will be ignored), and use the following syntax for the Connection URL:

jdbc:sqlserver://<SQL Server IP address>:<port>;integratedSecurity=true

Striim or the Forwarding Agent will use the Active Directory credentials for the user account of its process to authenticate with SQL Server.