Caveman's Blog

My commitment to learning.

SQL Server 2008: Ole Automation

with one comment


Ole Automation in SQL Server 2008 by default is turned off for security reasons. When OLE Automation Procedures are enabled, a call to sp_OACreate will start the OLE shared execution environment.

Executing the following script will enable Ole Automation

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
Advertisements

Written by cavemansblog

September 1, 2009 at 2:45 pm

One Response

Subscribe to comments with RSS.

  1. asp.net, c#,javascript…

    […]SQL Server 2008: Ole Automation « Caveman's Blog[…]…

    asp.net, c#,javascript

    September 29, 2011 at 8:14 pm


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

%d bloggers like this: