Member since
10-22-2019
4
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
8477 | 10-24-2019 06:38 AM |
04-01-2020
10:56 AM
Thank you Bjorn! saved me a headache in production when we go there. This setting worked for our SSIS users and service accounts also. I never even thought to tie that error message with that setting.
... View more
10-24-2019
06:38 AM
Well my systems guys have not figure out what causes this with our ODBC but at least i know i have the correct drivers and that I just have to install the driver as the service account we intend to run SSIS packages with
... View more
10-23-2019
06:36 AM
Ok thanks! I'll reach out to our windows / security team and see if they have any ideas of what could cause it. I just wanted to make sure I had the correct cloudera driver download for Servers, but seems like there is only 1 odbc hive dl available. On a side note, I also get a http 404 when trying to access the install guide on the site: https://docs.cloudera.com/documentation/other/connectors/hive-odbc/2-6-1/Cloudera-ODBC-Driver-for-Apache-Hive-Install-Guide.pdf
... View more
10-22-2019
12:31 PM
Hello community!
I have a weird issue where we are on Windows 2016 server that also runs Microsoft SSIS services, and I have installed the Cloudera ODBC Driver for Apache Hive v2.6.4.1004. When I install the ODBC with my personal account it will configure and test fine, but when we run a SSIS package using a different Run AS account that is not my personal AD account it fails with this error:
ERROR 1300 Connection::SQLDriverConnectW: [Cloudera][DriverSupport] (1030) Failed to decrypt data: Key not valid for use in specified state.
So my solution was to uninstall the ODBC driver on the windows server and re-install it using the Run As Service account we intend to use with SSIS.
I would like to know if this is intentional or I have a desktop driver when i should be using a server driver? Normally i do not like to log on to servers and install drivers with Service accounts.
Any information would be greatly appreciated!
Thanks, Jesse
... View more
Labels:
- Labels:
-
Apache Hive