Skip to main content
Question

SQL Server Error: "Unable to decrypt data"


martinjaeger
Contributor
Forum|alt.badge.img+3

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+3
  • 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

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


martinjaeger
Contributor
Forum|alt.badge.img+3
  • 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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings