Setting the Ole Automation Procedures server configuration option to 0

Ole Automation procedures are the extended stored procedures that enable the SQL server users to execute functions outside the SQL Server. Configuring the 'Ole Automation Procedures' server increases the attack surface of SQL Server and enables the users to execute functions in the security context of the SQL Server.

To enable the option, run this T-SQL command on both the IRC and the CM database:

EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE;
EXECUTE sp_configure 'Ole Automation Procedures', 0;
RECONFIGURE;
GO
EXECUTE sp_configure 'show advanced options', 0;
RECONFIGURE;