Azure SQL Server “clr strict security” can this be changed

I’m trying to change the ‘clr strict security’ in Azure SQL Server, but not able, is this no more possible in Azure Managed SQL Server.

I’ve created a certificate first and then I tried to create a login for the certificate and thats failing as well, is this changed and can this be done in some other way.

CREATE LOGIN MIRRepoCertLogin FROM CERTIFICATE MIRRepoCert; This is also failing with Keyword or statement option 'CERTIFICATE' is not supported in this version of SQL Server

My intention was to run the below commands in Azure SQL Server. Any advise.

EXEC sp_configure 'show advanced options', 1; 
RECONFIGURE with override;
EXEC sp_configure 'clr strict security', 0; 
RECONFIGURE with override; 
EXEC sp_configure 'show advanced options', 0; 
RECONFIGURE with override;

Answer

Important
As far as we know, the sp_configure and the SQL Statemenst of Certificate are not supported by Azure SQL Server.

When I try to execute the CREATE LOGIN xxx FROM CERTIFICATE xxx command. It shows the error is not supported in Azure Managed SQL Server.

When I try to execute the EXEC sp_configure command. It also shows is not supported

Advertisement

Answer