This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

PratFirm
New Contributor II

‎05-09-2018 09:24 AM

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, port, etc. However, I have Windows Authentication access to DB and able to access it from MS Server Management Studio. It says, connecting multiple times may lock db account. So not able to proceed further. Please advise.

0 Kudos
2 REPLIES 2

PratFirm
New Contributor II

‎05-16-2018 10:47 AM

Basically, I was trying to use Windows Authentication login into SQL Server. I came to know that SnapLogic is allowing only one option i.e. SQL Authentication method to connect to SQL Server. Hence I created explicit user and pass and used. Now it’s working fine. - Thanks

0 Kudos

sriram
Former Employee

‎05-17-2018 12:05 PM

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.