Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: I cant create DataSource Using MS SQLServer 2008 in Pentaho BI Server 5.1

  1. #1

    Default I cant create DataSource Using MS SQLServer 2008 in Pentaho BI Server 5.1

    Hi,

    I cant create a DataSource in Pentaho BI 5.1 using MSSqlServer 2008, I use jtds 1.3. is not possible connect succesfull this DataSource.

    Anybody try this before ?

    Please advices.

    Can this work using ODBC?

    Regards

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    I am using jtds 1.2.5 without any problem. What kind of error message did you get.

  3. #3

    Default

    I receive this message: DatasourceServiceImpl.ERROR_0009

  4. #4

    Default

    Quote Originally Posted by cristobaal View Post
    I receive this message: DatasourceServiceImpl.ERROR_0009
    Exactly this is the error: ConnectionServiceImpl.ERROR_0009 - Connection to Database DW failed
    DW Is my DB Name

  5. #5

    Default

    Hi Cris,

    Last year I had a chance to work on MS SQL Server 2008 and for me also same error and able to fix it not sure whether the below troubleshoot step will help you or not but you can give a try.
    1. Check your port number .
    a. open sql server configuration SQL SERVER NETWORK CONFIGURATION\PROTOCOLS FOR SQL SERVER LOCAL
    b. enable tcp\ip
    c. check IP ALL and use the same port number for connection.
    2. Check whether your server is allowing you to do authenticate using sql server authentication.
    3. For me I was connecting through SQLJDBC4.jar you can use it FYR sample JNDI connection is:

    test/type=javax.sql.DataSource
    test/driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    test/url=jdbc:sqlserver://localhost:63354;databaseName=test_db
    test/user=sa
    test/password=test@123
    Hope above will guide you in a right direction

  6. #6
    Join Date
    Aug 2006
    Posts
    287

    Default

    Using MS SQL JDBC Driver you are looking to use MS SQL Server (Native) type of connection on PUC

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.