Sample Header Ad - 728x90

Is there a way to use standard CLR functions on Azure SQL Edge for Ubuntu Docker on an M1 Mac?

7 votes
2 answers
5780 views
I have a MacBook with an M1 chip, so (about) the only option for me to run SQL Server is to [run it as a Docker container](https://database.guide/how-to-install-sql-server-on-an-m1-mac-arm64/) . This works fine for standard SQL, but our application uses some CLR features like [COMPRESS](https://learn.microsoft.com/en-us/sql/t-sql/functions/compress-transact-sql) ; when I try to use that, it tells me > Msg 50000, Level 16, State 1, Line 45 Common Language Runtime(CLR) is not enabled on this instance. [Enabling it](https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling) does not work:
EXEC sp_configure 'clr enabled', 1;  
RECONFIGURE;  
GO
gives > Msg 15392, Level 16, State 1, Procedure sp_configure, Line 166 The specified option 'clr enabled' is not supported by this edition of SQL Server and cannot be changed using sp_configure. I found [this Stack Overflow post](https://stackoverflow.com/q/59690813/4751173) but that is about someone using a custom .NET library; I'm looking for the 'standard' functionality available in SQL Server for Windows.
Asked by Glorfindel (2205 rep)
Feb 8, 2022, 10:45 AM
Last activity: Mar 13, 2023, 10:42 AM