sp_OACreate

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 Ole Automation Procedures in SQL Server Books Online.

 

Solution:

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;