This Advisory Condition check the state of the 'Ole Automation Procedures' configuration option.
Check
Q: Is the configuration disabled?
A: Disabled is correct in for this Advisory Condition.
If enabled is desired as the default then change "Does not equal" to "Equals"
Remediation
Enabling OLE
To enable Ole Automation Procedures run the following T-SQL code:
EXEC sp_configure 'show advanced options'
, 1;
RECONFIGURE;
EXEC sp_configure 'Ole Automation Procedures'
, 1;
RECONFIGURE;
Disabling OLE
To disable Ole Automation Procedures run the following T-SQL code:
EXEC sp_configure 'show advanced options'
, 1;
RECONFIGURE;
EXEC sp_configure 'Ole Automation Procedures'
, 0;
RECONFIGURE;
Validation
Run the following T-SQL code to check the status:
SELECT value
FROM sys.configurations
WHERE name = 'Ole Automation Procedures';
Resources: Ole Automation Procedures (server configuration option) - SQL Server | Microsoft Learn