In order to connect Workato to an on-premise Microsoft SQL Server database which requires NTLM authentication, these are the required steps:
- 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.
- Remove username & password tags and add integratedSecurity:true to your SQL Server profile on conf/config.yml
- 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.