Skip to main content
  • EN

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

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

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!

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


Community Stats

30,351
Posts
115,336
Replies
38,078
Members
Terms & ConditionsCookie settings
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.