Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: JNDI Connection for Windows Authentication to a Database not working.

  1. #1
    Join Date
    Dec 2010
    Posts
    193

    Default JNDI Connection for Windows Authentication to a Database not working.

    Hi,
    We are not able to connect to SQL server(Windows Authentication) through JNDI connection with the following details

    1C_MS_SPA_DB/type=javax.sql.DataSource
    1C_MS_SPA_DB/driver=net.sourceforge.jtds.jdbc.Driver
    1C_MS_SPA_DB/user=username
    1C_MS_SPA_DB/password=password
    1C_MS_SPA_DB/url=jdbc:jtds:sqlserver://SERVER IP:PORT NO ;DatabaseName= DatabaseName ;domain=domain; useNTLMV2=true

    We are able to connect through JDBC with same connection properties but with JNDI
    We are getting the below error

    Invalid JNDI connection 1C_MS_SPA_DB : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Invalid JNDI connection 1C_MS_SPA_DB : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

    We are using jtds-1.2.5 driver for SQL server.

  2. #2

    Default

    Quote Originally Posted by satran View Post
    Invalid JNDI connection 1C_MS_SPA_DB : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Invalid JNDI connection 1C_MS_SPA_DB : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

    We are using jtds-1.2.5 driver for SQL server.
    We have the very same problem, tried it with the SQL's native jdbc-drivers as well, but only odbc seems to work from a Windoze platform, and I would really prefer to get all things running from a linux platform.

  3. #3
    Join Date
    Jul 2012
    Posts
    200

    Default

    Hi

    Try to change it with this and restart

    abc/driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    abc/url=jdbc:sqlserver://xxxyyy.com:1433;databaseName=abc

    Quote Originally Posted by satran View Post
    Hi,
    We are not able to connect to SQL server(Windows Authentication) through JNDI connection with the following details

    1C_MS_SPA_DB/type=javax.sql.DataSource
    1C_MS_SPA_DB/driver=net.sourceforge.jtds.jdbc.Driver
    1C_MS_SPA_DB/user=username
    1C_MS_SPA_DB/password=password
    1C_MS_SPA_DB/url=jdbc:jtds:sqlserver://SERVER IP:PORT NO ;DatabaseName= DatabaseName ;domain=domain; useNTLMV2=true

    We are able to connect through JDBC with same connection properties but with JNDI
    We are getting the below error

    Invalid JNDI connection 1C_MS_SPA_DB : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Invalid JNDI connection 1C_MS_SPA_DB : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

    We are using jtds-1.2.5 driver for SQL server.
    Thanks & Regards
    yvkumar

  4. #4
    Join Date
    Dec 2010
    Posts
    193

    Default

    Kumar,

    Will that work in Unix environment too ?? And any specific drivers I need to place inside any of the folders ??

  5. #5
    Join Date
    Jul 2012
    Posts
    200

    Default

    I didnt tried with unix environment but u need to place the sqljdbc4.jar/sqljdbc.jar in the jdbc folder of dataintegration




    Quote Originally Posted by satran View Post
    Kumar,

    Will that work in Unix environment too ?? And any specific drivers I need to place inside any of the folders ??
    Last edited by yvkumar; 09-05-2012 at 12:25 AM.
    Thanks & Regards
    yvkumar

  6. #6
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by satran View Post
    Will that work in Unix environment too ??
    Windows Authentication with sqljdbc.jar relies on slqjdbc_auth.dll, so you will not be able to use this feature from a non-Windows box.
    So long, and thanks for all the fish.

Tags for this Thread

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.