You may see this error if the Ole Automation Procedures component is disabled on your SQL Server. This is a security configuration setting that is turned off by default and must be enabled by whoever manages your SQL Server installation.
Enable Ole Automation Procedures
A system administrator can enable Ole Automation Procedures using sp_configure. As this is an advanced SQL Server configuration, it must be carried out by your SQL Server administrator.
For guidance on how to enable this setting, search for Server configuration: Ole Automation Procedures on Microsoft Learn.
