In order to connect Workato to an on-premise Microsoft SQL Server database which requires NTLM authentication, these are the required steps:
- Add sqljdbc_auth.dll file to workato's OPA jre/bin directory. You can find this file inside Microsoft SQL Server JDBC Driver 6.4, available for download here.
- 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: if you are running Workato's OPA as a Windows Service, be sure to check which account is being used. By default, newly configured services run as "Local System", which is a system account with no permissions at all.