Error Connecting To Database Using Class Net.sourceforge.jtds.jdbc.driver
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Database connection in Pentaho Report Designer with MS SQL server 2008 up vote 1 down vote favorite While making a database connection in pentaho report designer using JDBC, I am getting the following error : Error connecting to database [database_name] : 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) Network error IOException: Permission denied: connect org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database sql-server jdbc pentaho share|improve this question asked Oct 18 '13 at 16:27 Mayank Sharma 1529 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote I can't comment unfortunately, and without more information my answer will be a shot in the dark, therefore I will attempt to describe the perfect connection that you can use to connect to SQL Server 2008 via JTDS. Put the jar that came with the JTDS package here: pentaho\report-designer\lib\jdbc. If you wish to take advantage of the Windows Authentication, also grab the ntmlauth.dll file and put it in either System32 (for 64 bit Windows) or SysWOW64 (for 32 bit Windows, that's up to your configuration*). Fire up report designer. New database connection: Give it a connection name. Set connection type to MS SQL Server, Native JDBC connection. The "MS SQL Server(Native)" connection did not work for me. Host name: the server's name where the Database sits. Server1, for example. Database Name: Take a wild guess what this might be. Yup, here you enter your database name. Northwind, for example. Instance name: Instance name, if you have any. Not mandatory. Port number: default SQL server port is 1433. User name / password:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a http://stackoverflow.com/questions/19454528/database-connection-in-pentaho-report-designer-with-ms-sql-server-2008 community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Pentaho data integration: jdbc connection to MS SQL Server not working up vote 1 down vote favorite With the community edition of Pentaho Data Integration - Kettle 5.0.1 (http://community.pentaho.com/projects/data-integration/) I could connect to http://stackoverflow.com/questions/32991978/pentaho-data-integration-jdbc-connection-to-ms-sql-server-not-working my MS SQL Server 2014 database with no issues, choosing MS SQL Serever and then Native (JDBC) from tools -? wizard -> create database connection. I have now upgraded to the latest 5.4 version, and I can no longer connect. The error I get is the following. Any suggestions on how to fix this? What I find confusing is that I can't find a way to tell Pentaho where excatly the jdbc drivers are. E.g. I downloaded Microsoft's JDBC drivers (https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774), but how do I get Pentaho to use them? I copied the file sqljdbc42.jar to c:\Pentaho\lib but to no avail. I also tried using it in the 'generic database' option but, again, to no avail. Error connecting to database [c] : 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) I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property. org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while try
Discussion jTDS - SQL Server and Sybase JDBC driver Brought to you by: ickzon Summary Files Reviews Support Donate Code Tickets https://sourceforge.net/p/jtds/discussion/104388/thread/9e4706a0/ ▾ Bugs Patches Feature Requests News Discussion Mailing Lists Create Topic Stats Graph Forums Help 1705 jTDS Developer 316 Open Discussion 245 Help Formatting Help JTDS - I/O Error: Unknown packet type 0x48 Forum: Open Discussion Creator: trangflower Created: 2005-01-03 Updated: 2012-08-15 trangflower - 2005-01-03 I am using Tomcat & SQL Server 2000 on WinXP. error connecting I'm using following code to connect to database: Classpath OK (jtds.jar - jtds-0.9). String dbDriver = "net.sourceforge.jtds.jdbc.Driver"; String strURL = "jdbc:jtds:sqlserver://localhost:8080/Website"; String strUserName = "sa"; String strPassword = "sa"; Class.forName(dbDriver); conn=DriverManager.getConnection(strURL,strUserName,strPassword); It throws exception: I/O Error: Unknown packet type 0x48 What can I do now? Thanks. If you would like to refer to this comment somewhere error connecting to else in this project, copy and paste the following link: Alin Sinpalean - 2005-01-04 Looking at the URL I think you're connecting to Tomcat (port 8080) instead of SQL Server (port 1433, probably). jTDS gets an 'HTTP 1.1 ...' error and is confused by the 'H' (0x48) which should be the packet type. Alin. If you would like to refer to this comment somewhere else in this project, copy and paste the following link: trangflower - 2005-01-04 Thanks, but when I edit it to: String dbDriver = "net.sourceforge.jtds.jdbc.Driver"; String strURL = "jdbc:jtds:sqlserver://localhost:1433/Website"; //Or "jdbc:jtds:sqlserver://localhost/Website" String strUserName = "sa"; String strPassword = "sa"; Class.forName(dbDriver); conn=DriverManager.getConnection(strURL,strUserName,strPassword); It throws exception: Network error IOException: Connection refused Please show me why? Thanks. If you would like to refer to this comment somewhere else in this project, copy and paste the following link: Alin Sinpalean - 2005-01-04 Probably because there's no SQL Server running on your machine or if there is, it's not listening on TCP/IP port 1433. Alin. If you woul