java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error occured while trying to connect to the database Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver) Unable to get information from SQL Server: DWK4001.

Pentaho BI Platform Tracking | Paul Blackburn | 8 years ago
  1. 0

    Get the error below when trying to connect to a MS SQL Server 2005 instance NOT running on the default port. To duplicate create a connection as follows Host Name : MyServer Database Name : MyDatabase Instance Name : MyInstance Port Number : 2433 Using NT authentification so no user name or password provided. However if I change the connection to specify the port directly after the host name then it works. Eg. Host Name : MyServer:2433 Database Name : MyDatabase Instance Name : MyInstance Port Number : 2433 Error stack below java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error occured while trying to connect to the database Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver) Unable to get information from SQL Server: DWK4001. at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:68) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error occured while trying to connect to the database Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver) Unable to get information from SQL Server: DWK4001. at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:320) at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:64) ... 1 more Caused by: 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) Unable to get information from SQL Server: DWK4001. at org.pentaho.di.core.database.Database.normalConnect(Database.java:318) at org.pentaho.di.core.database.Database.connect(Database.java:267) at org.pentaho.di.core.database.Database.connect(Database.java:229) at org.pentaho.di.core.database.Database.connect(Database.java:219) at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:168) ... 2 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver) Unable to get information from SQL Server: DWK4001. at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:435) at org.pentaho.di.core.database.Database.normalConnect(Database.java:302) ... 6 more Caused by: java.sql.SQLException: Unable to get information from SQL Server: DWK4001. at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:263) at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:421) ... 7 more

    Pentaho BI Platform Tracking | 8 years ago | Paul Blackburn
    java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error occured while trying to connect to the database Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver) Unable to get information from SQL Server: DWK4001.
  2. 0

    Connection URl for SQLExpress database using Hibernate

    Stack Overflow | 6 years ago | Hardik Mishra
    java.sql.SQLException: Unknown server host name 'COMP6\\SQLEXPRESS'. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.&lt;init&gt;(ConnectionJDBC2.java:401) at net.sourceforge.jtds.jdbc.ConnectionJDBC3.&lt;init&gt;(ConnectionJDBC3.java:50)
  3. 0

    BoneCP will not return or throw if connections are invalid

    Stack Overflow | 4 years ago | user432024
    java.sql.SQLException: Network error IOException: Connection refused: connect at net.sourceforge.jtds.jdbc.JtdsConnection.&lt;init&gt;(JtdsConnection.java:434) ~[jtds-1.3.0.jar:1.3.0]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    hibernate to MSSQL server Connection refused: connect

    Stack Overflow | 4 years ago | M364M4N cro
    java.sql.SQLException: Network error IOException: Connection refused: connect at net.sourceforge.jtds.jdbc.ConnectionJDBC2.&lt;init&gt;(ConnectionJDBC2.java:410) at net.sourceforge.jtds.jdbc.ConnectionJDBC3.&lt;init&gt;(ConnectionJDBC3.java:50)
  6. 0

    how to connect sql server 2008 from my android app

    Stack Overflow | 2 years ago | NoNo
    java.sql.SQLException: Network error IOException: socket failed: EACCES (Permission denied) at net.sourceforge.jtds.jdbc.JtdsConnection.&lt;init&gt;(JtdsConnection.java:436)

  1. abrazeneb 1 times, last 3 months ago
13 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Unable to get information from SQL Server: DWK4001.

    at net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>()
  2. jTDS
    Driver.connect
    1. net.sourceforge.jtds.jdbc.MSSqlServerInfo.<init>(MSSqlServerInfo.java:91)
    2. net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:263)
    3. net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
    4. net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
    4 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(Unknown Source)
    2. java.sql.DriverManager.getConnection(Unknown Source)
    2 frames
  4. org.pentaho.di
    GetDatabaseInfoProgressDialog$1.run
    1. org.pentaho.di.core.database.Database.connectUsingClass(Database.java:421)
    2. org.pentaho.di.core.database.Database.normalConnect(Database.java:302)
    3. org.pentaho.di.core.database.Database.connect(Database.java:267)
    4. org.pentaho.di.core.database.Database.connect(Database.java:229)
    5. org.pentaho.di.core.database.Database.connect(Database.java:219)
    6. org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:168)
    7. org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:64)
    7 frames
  5. JFace
    ModalContext$ModalContextThread.run
    1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
    1 frame