Forum Discussion

PratFirm's avatar
PratFirm
New Contributor II
8 years ago

Can SnapLogic connect using Windows Authentication to SQL Server Select snap?

Hi there, I am trying to connect to SQL Server Select snap during designing a pipeline. It’s giving error saying unable to connect to db even after providing the all required details like host, db,...
sriram's avatar
sriram
Former Employee
8 years ago
Copy LinkReport

The SQL Server snap pack does support Windows Authentication if you have a Snaplex that runs Windows. See below snippet from our documentation

  • Make sure that Snaplex is running Windows (Linux is not supported).
  • Place the latest version of sqljdbc_auth.dll in $SL_ROOT/ldlib (c:\opt\Snaplogic\ldlib). You can find latest the version of the DLL on the Microsoft SQLServer Server JDBC Driver website.
  • Configure an extra property for JDBC : “Integrated Security” = “true”

This community post is another good resource to refer to for this topic.