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
Source: http://jane.dallaway.com/blog/archive/2006_09_01_archive.html