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 sources is working fine, in which i used data import method. but when i use Direct Query method it's giving me this error "Failed to decrypt data: Key not valid for use in specified state". Pls help me. 

Please find below error screenshot

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.

9 Replies

  • 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.

         

         

    • 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!