Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Not able to connect MS Sql server from pentaho data integration

  1. #1
    Join Date
    Jun 2016
    Posts
    107

    Question Not able to connect MS Sql server from pentaho data integration

    Hi All,

    We are not able to connect MS Sql server database from Pentaho data integration tool, but that is connecting from aqua data studio query analyser.

    MS Sql server version : Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2 (X64)
    Jun 15 2019 00:26:19
    Copyright (C) 2017 Microsoft Corporation
    Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)
    kettle version : pdi-ce-6.1

    We are getting below error while connecting from kettle.

    Error connecting to database [USMEDIC-CUSTOMER] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occurred while trying to connect to the database


    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Login failed for user 'RemoteSQL'.




    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occurred while trying to connect to the database


    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Login failed for user 'RemoteSQL'.


    Please help me on this.

    Thanks in advance,
    Janu

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Can you connect to TCP1433 on the DB server from your PDI box?
    Do you have a Proxy Server in the environment?
    Are you certain that the password is correct?

    What basic troubleshooting have you done?
    Why are you not showing the complete stack trace?

    Aqua doesn't indicate what technology it uses to connect to systems. For all we know, it could be using ODBC.

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.