Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Pentaho User Console

  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Default Pentaho User Console

    I am having issues trying to connect to the SQL server (which is a VM in HyperV). I go into the Pentaho User Console and in trying to create a new connection, I keep running into an error.

    The error I am seeing is:

    Error connecting to database [XXXXX] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    Invalid URL: jdbc:jtds:sqlserver://XXX.XXX.XXX.83:1433/XXXXXDev

    org.pentaho.di.core.exception.KettleDatabaseExcep


    The SQL server has TCP/IP ports open. I have ensured that the SQL jar files from Microsoft for SQL Server 2012 have been put into the lib folders and I did restart the BA Server. Any suggestions out there?

    Thanks.

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    Did you download the jtds.jar file or the sqljdbc.jar file?

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.