Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: SQL Server Integrated Authentication is not working

  1. #1
    Join Date
    Jun 2009
    Posts
    28

    Default SQL Server Integrated Authentication is not working

    Win 7 SP1 64 bit
    SQL Server 2008 R2 64 bit
    Java 8 64 bit

    i was consistently getting an error that the jar could not be found.

    Error connecting to database [SALES_DM] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class com.microsoft.sqlserver.jdbc.SQLServerDriver)
    This driver is not configured for integrated authentication. ClientConnectionId:828bb26c-c16f-47e3-8598-319c44ef2b30

  2. #2
    Join Date
    Jun 2009
    Posts
    28

    Default

    i do have the x64\sqljdbc_auth.dll in the libswt\win64 folder.
    i also have the JAVA_HOME set to C:\Program Files\Java\jre1.8_25

  3. #3
    Join Date
    Jun 2009
    Posts
    28

    Default

    did some more testing with Java 7 and Java 8.
    i had to uninstall all the Java versions from my pc.
    Java 7 on any patch level and 32/64 bit, seemed to work with integrated authentication.

  4. #4
    Join Date
    Jun 2009
    Posts
    28

    Default

    i got it to work with Java 8.
    the default directory from Oracle's installation is C:\Program Files\Java\jre1.8_25.
    i believe that Pentaho is looking for a directory that is more like C:\Program Files\Java\jre8
    When installing, i changed the default directory to C:\Program Files\Java\jre8 and updated the JAVA_HOME to this value.
    then, the integrated authentication seemed to work.

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.