Forum Discussion

CIGRK's avatar
CIGRK
New Member
5 months ago
Solved

There was an error in the data gateway

Hello, I'm getting an error when trying to set up a connection to my gateway.  The error is: Unable to create connection for the following reason: There was an error in the data gateway.   It's n...
Need Help
  • CIGRK's avatar
    CIGRK
    5 months ago

    Thanks.  I actually just got it fixed.  I just re-created a brand new on-prem gateway vs using the recovery key after reinstall.  Copilot gave me a reason why that is, but I would have thought a recovery would have restored any keys needed to create a valid connection.  I'm new to all this and learning though.

Mauro89's avatar
Mauro89
Icon for Super User rankSuper User
5 months ago

Hi CIGRK, 

 

I never came across such an error message but here are some troubelshooting ideas which came into my mind:

 

1. Reset gateway encryption keys

  1. Uninstall the gateway completely
  2. Delete the gateway folder: C:\Program Files\On-premises data gateway
  3. Delete registry keys:
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\On-premises data gateway
  4. Restart the computer
  5. Reinstall the gateway fresh
  6. During installation, note the recovery key - save it securely

2. Check antivirus/encryption software

Some antivirus or disk encryption software might interferes with the gateway's cryptographic operations:

  • Temporarily disable antivirus

     

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution

 

  • CIGRK's avatar
    CIGRK
    New Member
    5 months ago

    Thanks.  I actually just got it fixed.  I just re-created a brand new on-prem gateway vs using the recovery key after reinstall.  Copilot gave me a reason why that is, but I would have thought a recovery would have restored any keys needed to create a valid connection.  I'm new to all this and learning though.

    • v-shchada-msft's avatar
      v-shchada-msft
      Icon for Community Support rankCommunity Support
      5 months ago

      Hello CIGRK,


      We appreciate your effort and are glad to hear that your issue has been resolved. Your update will also help other community members address similar issues more efficiently.

      Thank you.