OLE Automation on SQL Server RDS?


Is OLE Automation supported in SQL Server RDS? If not, what are the alternatives?

Thanks in advance.

1 Answer
Accepted Answer

The "Ole Automation Procedures" configuration is currently not supported with RDS SQL server due to RDS being a managed service. This is the default RDS engine security behavior, and not a bug.

As a workaround, you may run SQL Server on an EC2 instance as you would have less restrictions and would be able to execute both "sp_configure" and OLE automation procedures without any issues.

answered 4 months ago
  • Thanks so much.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions