Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Connection using Windows Authentication Mode for MS-SQL server

  1. #1

    Default Connection using Windows Authentication Mode for MS-SQL server

    Is there any way to use Windows Authentication mode(Local System Account) for the MS-SQL server so that when we configure a Transformation for SQLServer with we can use the same credentails as of the System Local account for connecting to the MS-SQL server Db.


  2. #2
    Join Date
    Dec 2009


    Hi Yogesh,

    I once configured a JDBC Connection with windows-authentication in our program (never tried this within a PDI connection, but it should be the same)
    What I did:
    - download the appropriate JDBC Driver from the Microsoft Homepage (do not use JTDS but the* Driver Class)
    - put the packaged DLL File (ships with the download) into a %PATH% folder (C:\windows\system32 did it for me)
    - use the correct credentials to connect to the SQL Server

    That should be all.
    Attention: When scheduling the transformation, verify, that this schedule is owned by the account which has the permission to connect to the SQL Server.



  3. #3


    Thank you Tom, for your quick response.
    I will try heading in the same direction and then let you know as well the results of my tests.


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.