Connect to On-Premise SQL Server with NTLM Authentication

In order to connect Workato to an on-premise Microsoft SQL Server database which requires NTLM authentication, these are the required steps:

1. This step only applies to Workato OPA inferior to 2.10. Newer versions already bring the MS SQL JDBC Driver bundled. Add sqljdbc_auth.dll file to workato's OPA jre/bin directory. You can find this file inside Microsoft SQL Server JDBC Driver, which is available to download from Microsoft's web site.
2. Remove username & password tags and add integratedSecurity:true  to your SQL Server profile on conf/config.yml
3. Your configuration should look like this:

# Example on premise SQL Server NTLM configuration
database:
   ntlmsqlserver:
     adapter: sqlserver
     host: <hostname>
     port: <port>
     database: <db>
     timeout: 30
     integratedSecurity: true

Note (1): NTLM Authentication applies only to Windows installations of Workato's OPA, it is therefore not possible to authenticate from a Linux machine using the Microsoft JDBC driver.

Note (2): Also if you are running Workato's OPA as a Windows Service, be sure to check which account is being used to run the service. By default, newly configured services run as "Local System", which is a system account with no permissions at all.