Skip to main content

Supporting Active Directory authentication for SQL Server

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

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

  2. Restart Striim (see Starting and stopping Striim Platform) or the Forwarding Agent (see Starting and stopping 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.