Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PDI 4.0.0 - windows authentication fails for Windows 64bit

  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Default PDI 4.0.0 - windows authentication fails for Windows 64bit

    Hi,
    I am doing some testing to decide whether Kettle cover our needs for an ETL tool but run into some issues. Maybe someone experienced the same issue.

    Here is the thing, I have some transformations that read data from a SQL server 2005, and need to access the DB with the windows credentials of the current user.

    when running the transformation on windows XP 32 bit machine, the windows authentication works fine. However when trying to do the same on a windows 7 64 bit, I get the error "SSO Failed: Native SSPI library not found".

    After going through the forum and other Internet sites, I am still lost.
    I have already tried placing the jtds jar file in libswt\win32 and libswt\win64 and the ntlmauth.dll file (version 64 and 32 bits) in c:\windows, c:\windows\system32 and c:\windows\sysWOW64 withtout any luck.

    Any ideas?
    Thanks in advance.

    Santiago

  2. #2

    Default

    Hi,

    the ntlmauth.dll is in kettle install\libswt\win32.

    Rgds

    Samatar
    Samatar

  3. #3
    Join Date
    Jul 2010
    Posts
    2

    Default

    Hi Samatar,
    Thanks for your quick reply.
    I've seen the file in the place you mention, but it simply wont work.
    It wasnt working either in my win XP 32 bits PC until I placed the dll under c:\windows\system32 folder.
    I am trying to do the same in the win 7 64 bits PC but no way...

    If I am not mistaken, libswt\win32 is included in the java.library.path when launching spoon.


    Santiago

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.