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

Source: http://jane.dallaway.com/blog/archive/2006_09_01_archive.html

 

Published Monday, November 13, 2006 10:00 AM by darenhan
Powered by Community Server (Commercial Edition), by Telligent Systems