Forum Discussion

dy's avatar
dy
New Member
4 years ago
Solved

ERROR [Simba][Driver Support] (1030) Failed to decrypt data: Key not valid for use in specific

Hi, It's been a week stuck on it. having error "Failed to decrypt data: Key not valid for use in specified state".  let me brief you about my scenario,  I'm using enterprise gateway. all data sour...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi dy ,

     

    Try the following solution from this link.

    Enable the setting to encrypt passwords for all users of the machine.

    1. Open ODBC Data Source Administrator.
    2. Find the Athena Data Source in question.
    3. Click on Configure.
    4. Click on Authentication Options.
    5. Click on Password Options.
    6. Select the "All Users of this Machine" radio button and click OK.
    7. Re-test the connection.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi dy ,

 

Try the following solution from this link.

Enable the setting to encrypt passwords for all users of the machine.

  1. Open ODBC Data Source Administrator.
  2. Find the Athena Data Source in question.
  3. Click on Configure.
  4. Click on Authentication Options.
  5. Click on Password Options.
  6. Select the "All Users of this Machine" radio button and click OK.
  7. Re-test the connection.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dyn's avatar
    dyn
    Frequent Visitor
    4 years ago

    Anonymous Realy greatful it works now that error has been fixed by performed suggested config however now i'm getting this error. pls have a look into this. Thanks again for your reply

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi dyn ,

       

      Are you dy ? Or is it just the same name?😂

      The error message shows that you don't seem to have a gateway configured for your data source.

      Please refer to 

      Add or remove a gateway data source - Power BI | Microsoft Docs

       

      Best Regards,

      Stephen Tao

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

       

      • dyn's avatar
        dyn
        Frequent Visitor
        4 years ago

        Anonymous Haha it's the same. i couldn't login with my previous account that's why create a new one. 

        One thing more wanna ask can we write query on power bi to get data from source if yes then how can we do this could you specify an example if i have to fetch from athena and want to write query in power bi to get data from athena 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous , can I ask what selecting "All Users of this machine" does?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you, Stephen Tao!

  • jarmer12's avatar
    jarmer12
    New Member
    1 year ago

    Hi I know this is an old thread, but I am getting the same error when trying to connect with BigQuery. Someone else with the same service credentials can access the data fine, but I get this error when trying to connect.