CLR in SQL 2019 : Permissions

• r5d4

  SSCrazy

  Points: 2523

  More actions

  December 14, 2020 at 8:49 pm

  #3820418

  I'm using an CLR which I've used plenty of times in the past and have running fine on SQL 2017.

  I've implemented on a database in SQL 2019 and functions runs fine, returning the desired results.

  When I try to run the same code via a sql agent job, I get ...

  .NET Framework execution was aborted. The UDP/UDF/CLR type did not revert thread token.

  The statement has been terminated.

  Similarly when I surround the code with EXECUTE AS LOGIN and REVERT it also fails.

  So this is down to the account this is running under.

  I started reading about signing , but the .DLL isn't my code (it's OpenPseudonymiser), I also found this about strict clr security https://www.sqlshack.com/impact-clr-strict-security-configuration-setting-sql-server-2017/

  Any help MUCH appreciated, i've spent too long on this.

   

   

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  December 15, 2020 at 9:10 pm

  #3820885

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Luca Cestola

  Newbie

  Points: 1

  More actions

  February 22, 2022 at 6:55 pm

  #3987059

  I know this post is quite old. Has anyone found the cause of this? It seems to be related to impersonation for me as well