Enable Ole Automation Procedures error

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  April 20, 2016 at 2:45 am

  #313427

  I'm troubleshooting an old SSIS package that connects to a 2005 SP4* instance. One of the steps fails with

  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

  so I enabled it with

  sp_configure 'Ole Automation Procedures', 1;

  GO

  and the result is

  Configuration option 'Ole Automation Procedures' changed from 1 to 1. Run the RECONFIGURE statement to install.

  but when I run

  SELECT value_in_use FROM sys.configurations WHERE name = 'Ole Automation Procedures';

  it returns 0.

  I tried RECONFIGURE and RECONFIGURE WITH OVERRIDE, but that produced this error message.

  Msg 5843, Level 16, State 1, Line 1

  Address Windowing Extensions (AWE) is not supported in this edition of SQL Server.

  which when I Googled it, didn't seem to be related.

  Does anybody know why I can't configure this setting? Thanks in advance.

  * I know, don't get me started.

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  April 20, 2016 at 8:49 am

  #1873365

  Bump in case anybody in the States is online and might know.

  Thanks.