MSSQL Linux Server Issue: SQL Server only supports SAFE assemblies

iSpiral Team 1 Reputation point
2019-12-05T12:25:08.717+00:00

Dear Support,

We recently came across an issue when trying to register some custom SQL CLR assemblies we have created on SQL Server 2017 v14.0.3238.1.

First of all, these assemblies require that they have External Access Permission, as they call external APIs. It seems that this issue is only appearing when trying to run them on an MSSQL Server that is hosted on a Linux Environment.

In addition, we have tried creating asymmetric keys (both with SN.exe tool from Microsoft SDKs and through VS 2017) and also signing these CLR assemblies, without any luck. (Followed instructions as found on: https://techcommunity.microsoft.com/t5/SQL-Server-Support/Deploying-SQL-CLR-assembly-using-Asymmetric-key/ba-p/316727)

When trying to register the assemblies, we are receiving the error:
"Assembly 'Sample_CLR' cannot be loaded because this edition of SQL Server only supports SAFE assemblies."

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
40,601 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,771 Reputation points
    2019-12-05T12:46:40.76+00:00

    SQL Server product is not yet migrated to this Microsoft QnA forum. So please post the same question on below dedicated one:

    .NET Framework inside SQL Server

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.