Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Connecting Pentaho DI to Microsoft SQL Server azzure

  1. #1

    Default Connecting Pentaho DI to Microsoft SQL Server azzure

    I make a connection like that:


    engine: sqlserver
    port: 1422
    host name: machine_name.database.windows.net
    database name: database_name


    And I got his error:


    Error connecting to database: (using class
    net.sourgeforge.jtds.jdbc.Driver)
    I/O Error: DB sercer closed connection


    I don't know if I have to use sqlserver(native) but
    I don't find this option in my version.
    Do I have to migrate to last pentaho version


    Any idea?


    Any help or advise will be greatly aprecciated

  2. #2
    Join Date
    Dec 2014
    Posts
    1

    Default

    Make sure you use Connections type MSSQL Server (Native) and Access Native (JDBC)

    Name:  connect.jpg
Views: 19
Size:  13.9 KB

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.