SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component ‘Ole Automation Procedures’

  SQL Advanced

To allow access to this component run the code below to activate.

 

Code:

-- Activate OLE Access
sp_configure 'show advanced options', 1

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