Question

SQL Server Error: "Unable to decrypt data"

  • 14 June 2024
  • 3 replies
  • 59 views

Badge +2

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

Badge +2

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
Userlevel 1
Badge +16

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!

Badge +2

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

Reply