Skip to main content
Question

SQL Server Error: "Unable to decrypt data"

  • June 14, 2024
  • 3 replies
  • 204 views
martinjaeger
Contributor
Forum|alt.badge.img+4

In FME Form 2024.0.1.0 I got an error when trying to read data or schema with “Microsoft SQL Server Non-Spatial” Reader: “Unable to decrypt data”. On the same server, connection with SQL Server Management Studio works fine.
Does anybody know this problem or has a solution?
Regards, Martin

3 replies

martinjaeger
Contributor
Forum|alt.badge.img+4
  • martinjaegerContributor
  • Author
  • Contributor
  • June 14, 2024

I have two additional informations:

  • the problem doesn’t occur with JDBC, only with ADO
  • the problem exists only for one windows user, therefore we are checking user rights and policies
virtualcitymatt
evieatsafe
Safer
  • evieatsafeSafer
  • Safer
  • June 18, 2024

Hi @martinjaeger, this sounds similar to something we’ve seen where registry keys were the cause of the error. (FMEFORM-31224) If you submit a support case we can help guide you through this process to see if this is the case or investigate further with you. Sorry for the inconvenience!

Happy to help - Evie
martinjaeger
Contributor
Forum|alt.badge.img+4
  • martinjaegerContributor
  • Author
  • Contributor
  • July 2, 2024

I deleted the file c:\Users\[UserName]\AppData\Roaming\Safe Software\FME\fme_userconnection.data
This solved my problem. Then I was able to add new connections and to connect to the SQL Server database

Community Stats

32,191
Posts
122,212
Replies
39,864
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.