Blocked Access to Procedure ‘sys.sp_OACreate’ of Component ‘Ole Automation Procedures’

Posted: March 18, 2011 in SQL Server 2005

If you ever get the 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 , you can enable this as follows:

From the actual application by going through Microsoft SQL Server 2005 | Configuration Tools | SQL 2005 Surface Area Configuration -> Surface Area Configuration for Features -> OLE Automation -> Enable OLE Automation.
OR
by running the following commands on SQL Server:

sp_configure 'show advanced options', 1; 
GO 
RECONFIGURE;
GO

sp_configure 'Ole Automation Procedures', 1; 
GO
RECONFIGURE;
GO 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s