HEELPBOOK - SQL Server - Blocked access to procedure 'sys.sp_OACreate'

The Error

Executed as user: Domain\SQLServiceAgent. 
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. [SQLSTATE 42000] (Error 15281). The step failed.

The message tells us exactly what to do, use sp_configure:


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;



############ ARTICLE INFO #############

Article Month: June
Article Date: 13/06/2012
Permalink: http://heelpbook.altervista.org/2012/sql-server-blocked-access-to-procedure-sys-sp_oacreate/
Source: http://sqlsolace.blogspot.it/2009/09/sql-server-blocked-access-to-procedure.html
Language: English

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook
Follow us on Delicious: http://delicious.com/heelpbook