• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Solutions Articles
  • Forums/Discussions
  • Submitted Tickets
Solution home App Resources SQL Server

Connect to On-Premise SQL Server with NTLM Authentication

Created by: Tiago Esperanca

Modified on: Wed, Jul 8, 2020 at 12:57 AM

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

  1. 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.
  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: 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.

T
Tiago is the author of this solution article.

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 2020   Privacy   Terms   +1 (844) 469-6752
    • Documentation
    • Workato Blog
    • Product Blog
    • Solutions
    • Forums
    • Tickets
    • Log in
    • Return to Workato