Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Pentaho and Window Authentication for MS SQL Server

  1. #1
    Join Date
    Sep 2014
    Posts
    175

    Default Pentaho and Window Authentication for MS SQL Server

    Hi again ---

    Posted this before but no luck.

    Currently, I can:

    1. Access MS SQL Server 2012 properly using Windows Authentication. I simply put in hostname\instance_name (also known as the server name) --- and voila, this connects to the entire instance (I don't choose a specific database)

    2. Access MS SQL Server VIA Pentaho, EXCEPT only with normal SQL login credentials, not Windows Authentication. This verifies the hostname\instance_name is correct in Pentaho. This option does gray out the port number, and the Win Auth doesn't, so it's possible the port number may not be 1433, but that may not be the problem.


    So where's the disconnect? The proper drivers in Pentaho?

    I have sqljdbc4.jar and sqljdbc_auth.dll in the proper lib folder, and have restarted spoon with them.

    Still, I get the same error message while using MS SQL Server (native) ---- Native (JDBC) ---- Use Integrated Security (checked):

    The TCP/IP connection to the host [redacted], port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
    Any thoughts? I'm willing to say screw it and just use a normal SQL user/ pass, but our security/ IT team is hesitant.
    Last edited by cool_runnings; 06-24-2015 at 06:09 PM.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    Try putting sqljdbc_auth.dll in %windir%\system32

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.