Blocked access to procedure 'sys.sp_OACreate of component 'Ole Automation Procedures in SQL Server 2005

If you are trying to use the Ole Automation Procedures and the option is turned off.

In SQL Server 2005, the option is disabled by default

In order to view the option, execute the following query

-- Show Advance Options, 0 = disabled, 1 = enabled
EXEC sp_configure 'show advanced options';
GO

-- Show Ole Automation Procedures, 0 = disabled, 1 = enabled
EXEC sp_configure 'Ole Automation Procedures';
GO

In order to enable Ole Automation option, execute the following query

 -- Enable the Advance options if they are not already turned on
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

-- Enable the Ole Automation Procedures
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO