SQL Server blocked access to procedure 'sys.sp_OACreate'

           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', see "Surface Area Configuration" in SQL Server Books Online. 

I got this error today. 

Way to solve it is to go into 

SQL 2005 surface area configuration -> For Features -> OLE Automation -> Enable OLE automation. 

OR u can use the following commands.

sp_configure 'show advanced options', 1

GO 

RECONFIGURE

GO 

sp_configure 'Ole Automation Procedures', 1

GO 

RECONFIGURE

GO