Wednesday, 16 September 2009

SQL Server blocked access to procedure 'sys.sp_OACreate'

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;

6 comments:

jscully said...

thanks that helped me

Unknown said...

Thanks for this - still works on SQL 2008 R2

Saurabh Jaiswal said...

Thnx, I almost forgot about this. Worked on 2008 R2

Saurabh Jaiswal said...

Thns, I almost forgot about it. Worked on 2008 R2

Dmitry Pavlov said...

Thanks! It saved my time

Graham Downs said...

Awesome! Worked for me in SQL2008 R2 Express :)