• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
Solution home App Resources SQL Server

Connect to On-Premise SQL Server with NTLM Authentication

Modified on: Mon, May 30, 2022 at 5:51 AM

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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

    Documentation
    Developer's Library
    Tutorials
    eBooks
    Product Hour
    Product Blog
    Workato Blog
    Product updates
    Customer Stories
    © Workato 2022   Privacy   Terms   +1 (844) 469-6752
    • Documentation
    • Workato Blog
    • Product Blog
    • Solutions
    • Forums
    • Tickets
    • Log in
    • Return to Workato
    Article views count