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:
    database name: database_name

    And I got his error:

    Error connecting to database: (using class
    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


    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.