Skip to main content

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

A
Written by Andrew McNeice
Updated over 2 months ago


​Error: "SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of Ole Automation Procedures' by using sp_configure.


​

For more information about enabling 'Ole Automation Procedures', search for 'Server configuration: Ole Automation Procedures'. There is an article on Microsoft Learn. It is disabled by default and seen as advanced configuration, so needs to be done by whoever manages your SQL Server installation.

Did this answer your question?