Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Can't connect to SQL 2K5/8 in Spoon CE 4.0.0

  1. #1
    Join Date
    Jul 2008
    Posts
    5

    Question Can't connect to SQL 2K5/8 in Spoon CE 4.0.0

    Use the new connection wizard in Spoon CE 4.0.0 to build a database connection (use the jTds driver) to SQL 2K5/8 with Windows authentication, it fails.

    Note: There is no issue though when use Spoon 3.2 GA to connect to the same db. I did more test by build a simple job with two transformations which uses a SQL 2K5 db connection, run the job in Spoon 3.2 and it works. It failed when I ran the same job in Spoon 4.0. However it works if I use the Kitchen 4.0 to run the job.

    Question: Is there any special setting/configuration required to use jTDS driver to connect to MS SQL or it is a bug for Spoon 4.0?

    Error connecting to database [Test] : 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)
    I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.


    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)
    I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

    org.pentaho.di.core.database.Database.normalConnect(Database.java:363)
    org.pentaho.di.core.database.Database.connect(Database.java:312)
    org.pentaho.di.core.database.Database.connect(Database.java:274)
    org.pentaho.di.core.database.Database.connect(Database.java:264)
    org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2431)
    org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    org.eclipse.jface.window.Window.open(Window.java:796)
    org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6254)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325)
    org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131)
    org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119)
    org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1147)
    org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6586)
    org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.pentaho.commons.launcher.Launcher.main(Launcher.java:110)
    Last edited by sliu; 08-16-2010 at 05:50 PM.

  2. #2
    Join Date
    Apr 2009
    Posts
    1

    Default

    I'm getting the same error...

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.