We have certain security requirements in order for our app to go live within our orgainisation.
We are using the Microsoft azure platform to host the application along with a Azure SQL server and database. To meet these security requirements, we need to configure settings on the server/database.
However we are running into issues using the default azure SQL server/database.
Here is an example. We need to "Disable 'clr enabled' option".
We have tried the following:
EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE;
EXECUTE sp_configure 'clr enabled', 0;
RECONFIGURE;
GO
EXECUTE sp_configure 'show advanced options', 0;
RECONFIGURE;
We run this in the T-SQL editor on the Azure platform, and receive the following:
Failed to execute query. Error: Statement 'CONFIG' is not supported in this version of SQL Server.
When we run the following, we see that is enabled.
SELECT name,
CAST(value as int) as value_configured,
CAST(value_in_use as int) as value_in_use
FROM sys.configurations
WHERE name = 'clr enabled';
How to we update these settings?
thanks.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…