Skip to main content

Error: 'SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'

What to do if you see an Ole Automation Procedures blocked access error in Orchestrate.

Written by Arthur Ashdown

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.

Did this answer your question?