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.

    -Thanks
    Yogesh

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    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 com.microsoft.* 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.

    HTH,

    Tom

  3. #3

    Default

    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.

    -Thanks
    Yogesh

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.